APPS.BEN_RGR_BUS dependencies on BEN_POPL_RPTG_GRP_F

Line 224: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_FK1');

220: --
221: -- raise error as FK does not relate to PK in ben_rptg_grp
222: -- table.
223: --
224: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_FK1');
225: --
226: end if;
227: --
228: close c1;

Line 286: from ben_popl_rptg_grp_f

282: --
283: --
284: cursor crs_pl_id is
285: select null
286: from ben_popl_rptg_grp_f
287: where pl_id = p_pl_id
288: and rptg_grp_id = nvl(p_rptg_grp_id, hr_api.g_number)
289: and business_group_id + 0 = p_business_group_id
290: and p_validate_start_date <= effective_end_date

Line 425: from ben_popl_rptg_grp_f

421: --
422: --
423: cursor csr_pgm_id is
424: select null
425: from ben_popl_rptg_grp_f
426: where pgm_id = p_pgm_id
427: and rptg_grp_id = nvl(p_rptg_grp_id, hr_api.g_number)
428: and business_group_id + 0 = p_business_group_id
429: and p_validate_start_date <= effective_end_date

Line 926: ben_popl_rptg_grp_f b

922: --
923: cursor csr_leg_code is
924: select a.legislation_code
925: from per_business_groups a,
926: ben_popl_rptg_grp_f b
927: where b.popl_rptg_grp_id = p_popl_rptg_grp_id
928: and a.business_group_id = b.business_group_id;
929: --
930: -- Declare local variables