APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_ENRT_PERD

Line 130: from ben_enrt_perd enp_c

126: p_asnd_lf_evt_dt is null or
127: ctu.enrt_perd_id is null or
128: exists (
129: select null
130: from ben_enrt_perd enp_c
131: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
132: enp_c.business_group_id=ctu.business_group_id and
133: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
134: )

Line 137: from ben_enrt_perd enp_c,

133: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
134: )
135: /* PB : 5422 :
136: select null
137: from ben_enrt_perd enp_c,
138: ben_enrt_perd enp_m
139: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
140: enp_c.business_group_id=ctu.business_group_id and
141: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 138: ben_enrt_perd enp_m

134: )
135: /* PB : 5422 :
136: select null
137: from ben_enrt_perd enp_c,
138: ben_enrt_perd enp_m
139: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
140: enp_c.business_group_id=ctu.business_group_id and
141: enp_m.enrt_perd_id=p_enrt_perd_id and
142: enp_m.business_group_id=ctu.business_group_id and

Line 201: from ben_enrt_perd enp_c

197: p_asnd_lf_evt_dt is null or
198: ctu.enrt_perd_id is null or
199: exists (
200: select null
201: from ben_enrt_perd enp_c
202: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
203: enp_c.business_group_id=ctu.business_group_id and
204: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
205: )

Line 208: from ben_enrt_perd enp_c,

204: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
205: )
206: /* PB : 5422 :
207: select null
208: from ben_enrt_perd enp_c,
209: ben_enrt_perd enp_m
210: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
211: enp_c.business_group_id=ctu.business_group_id and
212: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 209: ben_enrt_perd enp_m

205: )
206: /* PB : 5422 :
207: select null
208: from ben_enrt_perd enp_c,
209: ben_enrt_perd enp_m
210: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
211: enp_c.business_group_id=ctu.business_group_id and
212: enp_m.enrt_perd_id=p_enrt_perd_id and
213: enp_m.business_group_id=ctu.business_group_id and

Line 499: ben_enrt_perd enp,

495: select ctu.cm_typ_usg_id,
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

Line 555: ben_enrt_perd enp,

551: select ctu.cm_typ_usg_id,
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

Line 654: ben_enrt_perd enp,

650: select ctu.cm_typ_usg_id,
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

Line 1090: ben_enrt_perd enp,

1086: select ctu.cm_typ_usg_id,
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 */

Line 1179: ben_enrt_perd enp,

1175: select ctu.cm_typ_usg_id,
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 */

Line 1496: ben_enrt_perd enp,

1492: select ctu.cm_typ_usg_id,
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 */

Line 1575: ben_enrt_perd enp,

1571: select ctu.cm_typ_usg_id,
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 */

Line 1906: ) -- ???? 5422 : No need to join to ben_enrt_perd

1902: nvl(ctu.pgm_id,nvl(pel.pgm_id,-1)) = nvl(pel.pgm_id,-1)
1903: )
1904: ) or
1905: (ctu.enrt_perd_id is null)
1906: ) -- ???? 5422 : No need to join to ben_enrt_perd
1907: and ben_generate_communications.g_comm_start_date
1908: between ctu.effective_start_date
1909: and ctu.effective_end_date
1910: and ctu.cm_typ_id = p_cm_typ_id

Line 3467: from ben_enrt_perd enp

3463: and (p_asnd_lf_evt_dt is null or
3464: ctu.enrt_perd_id is null or
3465: ctu.enrt_perd_id =
3466: ( select enp.enrt_perd_id
3467: from ben_enrt_perd enp
3468: where enp.asnd_lf_evt_dt = enp.asnd_lf_evt_dt
3469: and enp.enrt_perd_id = pel.enrt_perd_id
3470: and enp.business_group_id = p_business_group_id
3471: )

Line 3524: from ben_enrt_perd enp

3520: and (p_asnd_lf_evt_dt is null or
3521: ctu.enrt_perd_id is null or
3522: ctu.enrt_perd_id =
3523: ( select enp.enrt_perd_id
3524: from ben_enrt_perd enp
3525: where enp.asnd_lf_evt_dt = enp.asnd_lf_evt_dt
3526: and enp.enrt_perd_id = pel.enrt_perd_id
3527: and enp.business_group_id = p_business_group_id
3528: )

Line 4148: from ben_enrt_perd enp,

4144: and (p_asnd_lf_evt_dt is null or
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