APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_ENRT_PERD

Line 1145: from ben_enrt_perd enp_c

1141: and (p_asnd_lf_evt_dt is null or
1142: ctu.enrt_perd_id is null or
1143: exists (
1144: select null
1145: from ben_enrt_perd enp_c
1146: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1147: enp_c.business_group_id=ctu.business_group_id and
1148: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1149: )

Line 1568: from ben_enrt_perd enp_c

1564: and (p_asnd_lf_evt_dt is null or
1565: ctu.enrt_perd_id is null or
1566: exists (
1567: select null
1568: from ben_enrt_perd enp_c
1569: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1570: enp_c.business_group_id=ctu.business_group_id and
1571: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1572: )

Line 1575: from ben_enrt_perd enp_c,

1571: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1572: )
1573: /* PB : 5422 :
1574: select null
1575: from ben_enrt_perd enp_c,
1576: ben_enrt_perd enp_m
1577: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1578: enp_c.business_group_id=ctu.business_group_id and
1579: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 1576: ben_enrt_perd enp_m

1572: )
1573: /* PB : 5422 :
1574: select null
1575: from ben_enrt_perd enp_c,
1576: ben_enrt_perd enp_m
1577: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1578: enp_c.business_group_id=ctu.business_group_id and
1579: enp_m.enrt_perd_id=p_enrt_perd_id and
1580: enp_m.business_group_id=ctu.business_group_id and

Line 1750: FROM ben_enrt_perd enp_c

1746: AND ( c_asnd_lf_evt_dt IS NULL
1747: OR ctu.enrt_perd_id IS NULL
1748: OR EXISTS (
1749: SELECT NULL
1750: FROM ben_enrt_perd enp_c
1751: WHERE enp_c.enrt_perd_id = ctu.enrt_perd_id
1752: AND enp_c.business_group_id = ctu.business_group_id
1753: AND enp_c.asnd_lf_evt_dt = c_asnd_lf_evt_dt)
1754: )

Line 1804: from ben_enrt_perd enp_c

1800: and (c_asnd_lf_evt_dt is null or
1801: ctu.enrt_perd_id is null or
1802: exists (
1803: select null
1804: from ben_enrt_perd enp_c
1805: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1806: enp_c.business_group_id=ctu.business_group_id and
1807: enp_c.asnd_lf_evt_dt = c_asnd_lf_evt_dt
1808: )

Line 2177: from ben_enrt_perd enp_c

2173: and (p_asnd_lf_evt_dt is null or
2174: ctu.enrt_perd_id is null or
2175: exists (
2176: select null
2177: from ben_enrt_perd enp_c
2178: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
2179: enp_c.business_group_id=ctu.business_group_id and
2180: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
2181: )

Line 2184: from ben_enrt_perd enp_c,

2180: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
2181: )
2182: /* PB : 5422 :
2183: select null
2184: from ben_enrt_perd enp_c,
2185: ben_enrt_perd enp_m
2186: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
2187: enp_c.business_group_id=ctu.business_group_id and
2188: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 2185: ben_enrt_perd enp_m

2181: )
2182: /* PB : 5422 :
2183: select null
2184: from ben_enrt_perd enp_c,
2185: ben_enrt_perd enp_m
2186: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
2187: enp_c.business_group_id=ctu.business_group_id and
2188: enp_m.enrt_perd_id=p_enrt_perd_id and
2189: enp_m.business_group_id=ctu.business_group_id and

Line 3147: from ben_enrt_perd enp_c

3143: and (p_asnd_lf_evt_dt is null or
3144: ctu.enrt_perd_id is null or
3145: exists (
3146: select null
3147: from ben_enrt_perd enp_c
3148: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3149: enp_c.business_group_id=ctu.business_group_id and
3150: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3151: )

Line 3431: from ben_enrt_perd enp_c

3427: and (p_asnd_lf_evt_dt is null or
3428: ctu.enrt_perd_id is null or
3429: exists (
3430: select null
3431: from ben_enrt_perd enp_c
3432: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3433: enp_c.business_group_id=ctu.business_group_id and
3434: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3435: )

Line 3438: from ben_enrt_perd enp_c,

3434: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3435: )
3436: /* PB : 5422 :
3437: select null
3438: from ben_enrt_perd enp_c,
3439: ben_enrt_perd enp_m
3440: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3441: enp_c.business_group_id=ctu.business_group_id and
3442: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 3439: ben_enrt_perd enp_m

3435: )
3436: /* PB : 5422 :
3437: select null
3438: from ben_enrt_perd enp_c,
3439: ben_enrt_perd enp_m
3440: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3441: enp_c.business_group_id=ctu.business_group_id and
3442: enp_m.enrt_perd_id=p_enrt_perd_id and
3443: enp_m.business_group_id=ctu.business_group_id and

Line 3599: from ben_enrt_perd enp_c

3595: and (p_asnd_lf_evt_dt is null or
3596: ctu.enrt_perd_id is null or
3597: exists (
3598: select null
3599: from ben_enrt_perd enp_c
3600: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3601: enp_c.business_group_id=ctu.business_group_id and
3602: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3603: )

Line 3606: from ben_enrt_perd enp_c,

3602: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3603: )
3604: /* PB : 5422 :
3605: select null
3606: from ben_enrt_perd enp_c,
3607: ben_enrt_perd enp_m
3608: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3609: enp_c.business_group_id=ctu.business_group_id and
3610: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 3607: ben_enrt_perd enp_m

3603: )
3604: /* PB : 5422 :
3605: select null
3606: from ben_enrt_perd enp_c,
3607: ben_enrt_perd enp_m
3608: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3609: enp_c.business_group_id=ctu.business_group_id and
3610: enp_m.enrt_perd_id=p_enrt_perd_id and
3611: enp_m.business_group_id=ctu.business_group_id and

Line 3887: from ben_enrt_perd enp_c

3883: and (p_asnd_lf_evt_dt is null or
3884: ctu.enrt_perd_id is null or
3885: exists (
3886: select null
3887: from ben_enrt_perd enp_c
3888: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3889: enp_c.business_group_id=ctu.business_group_id and
3890: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3891: )