APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_ENRT_PERD

Line 957: from ben_enrt_perd enp_c

953: and (p_asnd_lf_evt_dt is null or
954: ctu.enrt_perd_id is null or
955: exists (
956: select null
957: from ben_enrt_perd enp_c
958: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
959: enp_c.business_group_id=ctu.business_group_id and
960: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
961: )

Line 1329: from ben_enrt_perd enp_c

1325: and (p_asnd_lf_evt_dt is null or
1326: ctu.enrt_perd_id is null or
1327: exists (
1328: select null
1329: from ben_enrt_perd enp_c
1330: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1331: enp_c.business_group_id=ctu.business_group_id and
1332: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1333: )

Line 1336: from ben_enrt_perd enp_c,

1332: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1333: )
1334: /* PB : 5422 :
1335: select null
1336: from ben_enrt_perd enp_c,
1337: ben_enrt_perd enp_m
1338: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1339: enp_c.business_group_id=ctu.business_group_id and
1340: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 1337: ben_enrt_perd enp_m

1333: )
1334: /* PB : 5422 :
1335: select null
1336: from ben_enrt_perd enp_c,
1337: ben_enrt_perd enp_m
1338: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1339: enp_c.business_group_id=ctu.business_group_id and
1340: enp_m.enrt_perd_id=p_enrt_perd_id and
1341: enp_m.business_group_id=ctu.business_group_id and

Line 1511: FROM ben_enrt_perd enp_c

1507: AND ( c_asnd_lf_evt_dt IS NULL
1508: OR ctu.enrt_perd_id IS NULL
1509: OR EXISTS (
1510: SELECT NULL
1511: FROM ben_enrt_perd enp_c
1512: WHERE enp_c.enrt_perd_id = ctu.enrt_perd_id
1513: AND enp_c.business_group_id = ctu.business_group_id
1514: AND enp_c.asnd_lf_evt_dt = c_asnd_lf_evt_dt)
1515: )

Line 1565: from ben_enrt_perd enp_c

1561: and (c_asnd_lf_evt_dt is null or
1562: ctu.enrt_perd_id is null or
1563: exists (
1564: select null
1565: from ben_enrt_perd enp_c
1566: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1567: enp_c.business_group_id=ctu.business_group_id and
1568: enp_c.asnd_lf_evt_dt = c_asnd_lf_evt_dt
1569: )

Line 1938: from ben_enrt_perd enp_c

1934: and (p_asnd_lf_evt_dt is null or
1935: ctu.enrt_perd_id is null or
1936: exists (
1937: select null
1938: from ben_enrt_perd enp_c
1939: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1940: enp_c.business_group_id=ctu.business_group_id and
1941: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1942: )

Line 1945: from ben_enrt_perd enp_c,

1941: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
1942: )
1943: /* PB : 5422 :
1944: select null
1945: from ben_enrt_perd enp_c,
1946: ben_enrt_perd enp_m
1947: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1948: enp_c.business_group_id=ctu.business_group_id and
1949: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 1946: ben_enrt_perd enp_m

1942: )
1943: /* PB : 5422 :
1944: select null
1945: from ben_enrt_perd enp_c,
1946: ben_enrt_perd enp_m
1947: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
1948: enp_c.business_group_id=ctu.business_group_id and
1949: enp_m.enrt_perd_id=p_enrt_perd_id and
1950: enp_m.business_group_id=ctu.business_group_id and

Line 2908: from ben_enrt_perd enp_c

2904: and (p_asnd_lf_evt_dt is null or
2905: ctu.enrt_perd_id is null or
2906: exists (
2907: select null
2908: from ben_enrt_perd enp_c
2909: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
2910: enp_c.business_group_id=ctu.business_group_id and
2911: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
2912: )

Line 3192: from ben_enrt_perd enp_c

3188: and (p_asnd_lf_evt_dt is null or
3189: ctu.enrt_perd_id is null or
3190: exists (
3191: select null
3192: from ben_enrt_perd enp_c
3193: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3194: enp_c.business_group_id=ctu.business_group_id and
3195: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3196: )

Line 3199: from ben_enrt_perd enp_c,

3195: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3196: )
3197: /* PB : 5422 :
3198: select null
3199: from ben_enrt_perd enp_c,
3200: ben_enrt_perd enp_m
3201: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3202: enp_c.business_group_id=ctu.business_group_id and
3203: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 3200: ben_enrt_perd enp_m

3196: )
3197: /* PB : 5422 :
3198: select null
3199: from ben_enrt_perd enp_c,
3200: ben_enrt_perd enp_m
3201: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3202: enp_c.business_group_id=ctu.business_group_id and
3203: enp_m.enrt_perd_id=p_enrt_perd_id and
3204: enp_m.business_group_id=ctu.business_group_id and

Line 3360: from ben_enrt_perd enp_c

3356: and (p_asnd_lf_evt_dt is null or
3357: ctu.enrt_perd_id is null or
3358: exists (
3359: select null
3360: from ben_enrt_perd enp_c
3361: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3362: enp_c.business_group_id=ctu.business_group_id and
3363: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3364: )

Line 3367: from ben_enrt_perd enp_c,

3363: enp_c.asnd_lf_evt_dt = p_asnd_lf_evt_dt
3364: )
3365: /* PB : 5422 :
3366: select null
3367: from ben_enrt_perd enp_c,
3368: ben_enrt_perd enp_m
3369: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3370: enp_c.business_group_id=ctu.business_group_id and
3371: enp_m.enrt_perd_id=p_enrt_perd_id and

Line 3368: ben_enrt_perd enp_m

3364: )
3365: /* PB : 5422 :
3366: select null
3367: from ben_enrt_perd enp_c,
3368: ben_enrt_perd enp_m
3369: where enp_c.enrt_perd_id=ctu.enrt_perd_id and
3370: enp_c.business_group_id=ctu.business_group_id and
3371: enp_m.enrt_perd_id=p_enrt_perd_id and
3372: enp_m.business_group_id=ctu.business_group_id and