-- Slice 8Z-u · PR navigation wiring
--
-- Adds:
--  1) PaymentRequests.my perm for Procurement + Administrator (roll-up of PRs the user raised).

INSERT INTO user_groups_perms (user_group_id, controller_allowed, action_allowed, created_by, created_on)
SELECT g.c0d, 'PaymentRequests', 'my', 0, NOW()
FROM user_groups g
WHERE g.user_group_name IN ('Procurement','Administrator')
  AND NOT EXISTS (SELECT 1 FROM user_groups_perms p WHERE p.user_group_id = g.c0d AND p.controller_allowed = 'PaymentRequests' AND p.action_allowed = 'my');
