APPS.BEN_RECN_REP dependencies on BEN_POPL_RPTG_GRP_F

Line 337: from ben_popl_rptg_grp_f prpg

333: and (p_benfts_grp_id is null
334: or per.benefit_group_id = p_benfts_grp_id)
335: and (p_rptg_grp_id is null
336: or exists (select null
337: from ben_popl_rptg_grp_f prpg
338: where (pen.pl_id = prpg.pl_id
339: or pen.pgm_id = prpg.pgm_id )
340: and prpg.rptg_grp_id = p_rptg_grp_id))
341: ) pl

Line 441: from ben_popl_rptg_grp_f prpg

437: and (p_benfts_grp_id is null
438: or per.benefit_group_id = p_benfts_grp_id)
439: and (p_rptg_grp_id is null
440: or exists (select null
441: from ben_popl_rptg_grp_f prpg
442: where (pen.pl_id = prpg.pl_id
443: or pen.pgm_id = prpg.pgm_id )
444: and prpg.rptg_grp_id = p_rptg_grp_id))
445: ) pl

Line 531: from ben_popl_rptg_grp_f prpg

527: and (p_benfts_grp_id is null
528: or per.benefit_group_id = p_benfts_grp_id)
529: and (p_rptg_grp_id is null
530: or exists (select null
531: from ben_popl_rptg_grp_f prpg
532: where (pen.pl_id = prpg.pl_id
533: or pen.pgm_id = prpg.pgm_id )
534: and prpg.rptg_grp_id = p_rptg_grp_id))
535: order by 1,2,3,4) pl

Line 615: from ben_popl_rptg_grp_f prpg

611: and (p_benfts_grp_id is null
612: or per.benefit_group_id = p_benfts_grp_id)
613: and (p_rptg_grp_id is null
614: or exists (select null
615: from ben_popl_rptg_grp_f prpg
616: where (pen.pl_id = prpg.pl_id
617: or pen.pgm_id = prpg.pgm_id )
618: and prpg.rptg_grp_id = p_rptg_grp_id))
619: order by 1,2,3,4,5;

Line 1336: from ben_popl_rptg_grp_f prpg

1332: and (p_benfts_grp_id is null
1333: or per.benefit_group_id = p_benfts_grp_id)
1334: and (p_rptg_grp_id is null
1335: or exists (select null
1336: from ben_popl_rptg_grp_f prpg
1337: where pen.pl_id = prpg.pl_id(+)
1338: and pen.pgm_id = prpg.pgm_id(+)
1339: and prpg.rptg_grp_id = p_rptg_grp_id));
1340: --