APPS.BEN_CWB_POST_PROCESS dependencies on BEN_CWB_PERSON_GROUPS

Line 302: FROM ben_cwb_person_groups grp

298: IS
299: SELECT object_version_number
300: ,access_cd
301: ,approval_cd
302: FROM ben_cwb_person_groups grp
303: WHERE grp.group_per_in_ler_id = v_group_per_in_ler_id
304: AND grp.group_pl_id = v_group_pl_id
305: AND grp.group_oipl_id = v_group_oipl_id;
306:

Line 984: ,ben_cwb_person_groups pgroup

980: IS
981: SELECT pil.per_in_ler_id
982: ,nvl(info.custom_name,info.full_name) full_name
983: FROM ben_per_in_ler pil
984: ,ben_cwb_person_groups pgroup
985: ,ben_cwb_person_info info
986: WHERE pil.lf_evt_ocrd_dt = v_lf_evt_ocrd_dt
987: AND pil.group_pl_id = v_group_pl_id
988: AND pgroup.group_per_in_ler_id = pil.per_in_ler_id

Line 1348: ben_cwb_person_groups_api.update_group_budget

1344: (nvl(l_grp_ovn.access_cd,'UP') = 'UP' OR nvl(l_grp_ovn.approval_cd, 'AP') = 'AP')
1345: THEN
1346: write_m('Access and approval cd update for '||l_pils_for_access.full_name);
1347: BEGIN
1348: ben_cwb_person_groups_api.update_group_budget
1349: (p_group_per_in_ler_id => l_pils_for_access.per_in_ler_id
1350: , p_group_pl_id => p_group_pl_id
1351: , p_group_oipl_id => -1
1352: , p_access_cd => 'RO'