APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 500: ben_popl_enrt_typ_cycl_f pet

496: ctu.cm_usg_rl
497: from ben_cm_typ_usg_f ctu,
498: ben_elig_per_f pep,
499: ben_enrt_perd enp,
500: ben_popl_enrt_typ_cycl_f pet
501: where ctu.business_group_id = p_business_group_id
502: /* First join comp objects */
503: and pep.business_group_id = ctu.business_group_id
504: and pep.person_id = p_person_id

Line 556: ben_popl_enrt_typ_cycl_f pet

552: ctu.cm_usg_rl
553: from ben_cm_typ_usg_f ctu,
554: ben_elig_per_f pep,
555: ben_enrt_perd enp,
556: ben_popl_enrt_typ_cycl_f pet
557: where ctu.business_group_id = p_business_group_id
558: /* First join comp objects */
559: and pep.business_group_id = ctu.business_group_id
560: and pep.person_id = p_person_id

Line 655: ben_popl_enrt_typ_cycl_f pet

651: ctu.cm_usg_rl
652: from ben_cm_typ_usg_f ctu,
653: ben_elig_per_f pep,
654: ben_enrt_perd enp,
655: ben_popl_enrt_typ_cycl_f pet
656: where ctu.business_group_id = p_business_group_id
657: /* First join comp objects */
658: and pep.business_group_id = ctu.business_group_id
659: and pep.person_id = p_person_id

Line 1091: ben_popl_enrt_typ_cycl_f pet,

1087: ctu.cm_usg_rl
1088: from ben_cm_typ_usg_f ctu,
1089: ben_prtt_enrt_rslt_f pen,
1090: ben_enrt_perd enp,
1091: ben_popl_enrt_typ_cycl_f pet,
1092: ben_prtt_rt_val prv
1093: where ctu.business_group_id = p_business_group_id
1094: /* First join comp objects */
1095: and prv.business_group_id = ctu.business_group_id

Line 1180: ben_popl_enrt_typ_cycl_f pet,

1176: ctu.cm_usg_rl
1177: from ben_cm_typ_usg_f ctu,
1178: ben_prtt_enrt_rslt_f pen,
1179: ben_enrt_perd enp,
1180: ben_popl_enrt_typ_cycl_f pet,
1181: ben_prtt_rt_val prv
1182: where ctu.business_group_id = p_business_group_id
1183: /* First join comp objects */
1184: and prv.business_group_id = ctu.business_group_id

Line 1497: ben_popl_enrt_typ_cycl_f pet

1493: ctu.cm_usg_rl
1494: from ben_cm_typ_usg_f ctu,
1495: ben_prtt_enrt_rslt_f pen,
1496: ben_enrt_perd enp,
1497: ben_popl_enrt_typ_cycl_f pet
1498: where ctu.business_group_id = p_business_group_id
1499: and pen.prtt_enrt_rslt_stat_cd is null
1500: /* First join comp objects */
1501: and pen.business_group_id = ctu.business_group_id

Line 1576: ben_popl_enrt_typ_cycl_f pet

1572: ctu.cm_usg_rl
1573: from ben_cm_typ_usg_f ctu,
1574: ben_prtt_enrt_rslt_f pen,
1575: ben_enrt_perd enp,
1576: ben_popl_enrt_typ_cycl_f pet
1577: where ctu.business_group_id = p_business_group_id
1578: and pen.prtt_enrt_rslt_stat_cd is null
1579: /* First join comp objects */
1580: and pen.business_group_id = ctu.business_group_id

Line 4149: ben_popl_enrt_typ_cycl_f pet

4145: ctu.enrt_perd_id is null or
4146: ctu.enrt_perd_id =
4147: ( select enp.enrt_perd_id
4148: from ben_enrt_perd enp,
4149: ben_popl_enrt_typ_cycl_f pet
4150: where enp.asnd_lf_evt_dt = enp.asnd_lf_evt_dt
4151: and enp.popl_enrt_typ_cycl_id = pet.popl_enrt_typ_cycl_id
4152: and (p_pl_id is null or
4153: nvl(pet.pl_id,p_pl_id) = p_pl_id)