APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_CM_TYP_USG_F

Line 110: from ben_cm_typ_usg_f ctu,

106: --
107: cursor c_dpnt_usage is
108: select ctu.cm_typ_usg_id,
109: ctu.cm_usg_rl
110: from ben_cm_typ_usg_f ctu,
111: ben_per_in_ler pil,
112: ben_elig_per_elctbl_chc epe
113: where pil.per_in_ler_id = p_per_in_ler_id
114: and pil.business_group_id = p_business_group_id

Line 181: from ben_cm_typ_usg_f ctu,

177: --
178: cursor c_bnf_usage is
179: select ctu.cm_typ_usg_id,
180: ctu.cm_usg_rl
181: from ben_cm_typ_usg_f ctu,
182: ben_per_in_ler pil,
183: ben_elig_per_elctbl_chc epe
184: where pil.per_in_ler_id = p_per_in_ler_id
185: and pil.business_group_id = p_business_group_id

Line 497: from ben_cm_typ_usg_f ctu,

493: --
494: cursor c_dpnt_usage is
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

Line 553: from ben_cm_typ_usg_f ctu,

549: --
550: cursor c_rltd_per_usage is
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

Line 652: from ben_cm_typ_usg_f ctu,

648: --
649: cursor c_bnf_usage is
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

Line 1088: from ben_cm_typ_usg_f ctu,

1084: --
1085: cursor c_bnf_usage is
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

Line 1177: from ben_cm_typ_usg_f ctu,

1173: --
1174: cursor c_dpnt_usage is
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

Line 1494: from ben_cm_typ_usg_f ctu,

1490: --
1491: cursor c_bnf_usage is
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

Line 1573: from ben_cm_typ_usg_f ctu,

1569: --
1570: cursor c_dpnt_usage is
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

Line 1879: from ben_cm_typ_usg_f ctu,

1875: --
1876: cursor c_bnf_usage is
1877: select ctu.cm_typ_usg_id,
1878: ctu.cm_usg_rl
1879: from ben_cm_typ_usg_f ctu,
1880: ben_prtt_enrt_rslt_f pen,
1881: ben_pil_elctbl_chc_popl pel
1882: where ctu.business_group_id = p_business_group_id
1883: and pen.prtt_enrt_rslt_stat_cd is null

Line 1945: from ben_cm_typ_usg_f ctu,

1941: --
1942: cursor c_dpnt_usage is
1943: select ctu.cm_typ_usg_id,
1944: ctu.cm_usg_rl
1945: from ben_cm_typ_usg_f ctu,
1946: ben_prtt_enrt_rslt_f pen,
1947: ben_pil_elctbl_chc_popl pel
1948: where ctu.business_group_id = p_business_group_id
1949: and pen.prtt_enrt_rslt_stat_cd is null

Line 2231: from ben_cm_typ_usg_f ctu,

2227: --
2228: cursor c_dpnt_usage is
2229: select ctu.cm_typ_usg_id,
2230: ctu.cm_usg_rl
2231: from ben_cm_typ_usg_f ctu,
2232: ben_pil_elctbl_chc_popl pel
2233: where ctu.business_group_id = p_business_group_id
2234: and pel.business_group_id = ctu.business_group_id
2235: and pel.per_in_ler_id = p_per_in_ler_id

Line 2274: from ben_cm_typ_usg_f ctu,

2270: --
2271: cursor c_bnf_usage is
2272: select ctu.cm_typ_usg_id,
2273: ctu.cm_usg_rl
2274: from ben_cm_typ_usg_f ctu,
2275: ben_pil_elctbl_chc_popl pel
2276: where ctu.business_group_id = p_business_group_id
2277: and pel.business_group_id = ctu.business_group_id
2278: and pel.per_in_ler_id = p_per_in_ler_id

Line 2538: from ben_cm_typ_usg_f ctu

2534: --
2535: cursor c_bnf_usage is
2536: select ctu.cm_typ_usg_id,
2537: ctu.cm_usg_rl
2538: from ben_cm_typ_usg_f ctu
2539: where ctu.business_group_id = p_business_group_id
2540: and (p_ler_id is null or
2541: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
2542: and (p_pgm_id is null or

Line 2611: from ben_cm_typ_usg_f ctu

2607: --
2608: cursor c_dpnt_usage is
2609: select ctu.cm_typ_usg_id,
2610: ctu.cm_usg_rl
2611: from ben_cm_typ_usg_f ctu
2612: where ctu.business_group_id = p_business_group_id
2613: and (p_ler_id is null or
2614: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
2615: and (p_pgm_id is null or

Line 2907: from ben_cm_typ_usg_f ctu

2903: --
2904: cursor c_dpnt_usage is
2905: select ctu.cm_typ_usg_id,
2906: ctu.cm_usg_rl
2907: from ben_cm_typ_usg_f ctu
2908: where ctu.business_group_id = p_business_group_id
2909: and (p_pgm_id is null or
2910: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
2911: and (p_pl_id is null or

Line 3106: from ben_cm_typ_usg_f ctu

3102: --
3103: cursor c_dpnt_usage is
3104: select ctu.cm_typ_usg_id,
3105: ctu.cm_usg_rl
3106: from ben_cm_typ_usg_f ctu
3107: where ctu.business_group_id = p_business_group_id
3108: and (p_pgm_id is null or
3109: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
3110: and (p_pl_id is null or

Line 3161: from ben_cm_typ_usg_f ctu

3157: --
3158: cursor c_bnf_usage is
3159: select ctu.cm_typ_usg_id,
3160: ctu.cm_usg_rl
3161: from ben_cm_typ_usg_f ctu
3162: where ctu.business_group_id = p_business_group_id
3163: and (p_pgm_id is null or
3164: nvl(ctu.pgm_id,p_pgm_id) = p_pgm_id)
3165: and (p_pl_id is null or

Line 3447: from ben_cm_typ_usg_f ctu,

3443: --
3444: cursor c_dpnt_usage is
3445: select ctu.cm_typ_usg_id,
3446: ctu.cm_usg_rl
3447: from ben_cm_typ_usg_f ctu,
3448: ben_pil_elctbl_chc_popl pel
3449: where ctu.business_group_id = p_business_group_id
3450: and pel.business_group_id = ctu.business_group_id
3451: and (p_ler_id is null or

Line 3504: from ben_cm_typ_usg_f ctu,

3500: --
3501: cursor c_bnf_usage is
3502: select ctu.cm_typ_usg_id,
3503: ctu.cm_usg_rl
3504: from ben_cm_typ_usg_f ctu,
3505: ben_pil_elctbl_chc_popl pel
3506: where ctu.business_group_id = p_business_group_id
3507: and pel.business_group_id = ctu.business_group_id
3508: and (p_ler_id is null or

Line 3790: from ben_cm_typ_usg_f ctu

3786: --
3787: cursor c_dpnt_usage is
3788: select ctu.cm_typ_usg_id,
3789: ctu.cm_usg_rl
3790: from ben_cm_typ_usg_f ctu
3791: where ctu.business_group_id = p_business_group_id
3792: and (p_pl_id is null or
3793: nvl(ctu.pl_id,p_pl_id) = p_pl_id)
3794: and (p_pgm_id is null or

Line 3846: from ben_cm_typ_usg_f ctu

3842: --
3843: cursor c_bnf_usage is
3844: select ctu.cm_typ_usg_id,
3845: ctu.cm_usg_rl
3846: from ben_cm_typ_usg_f ctu
3847: where ctu.business_group_id = p_business_group_id
3848: and (p_pl_id is null or
3849: nvl(ctu.pl_id,p_pl_id) = p_pl_id)
3850: and (p_pgm_id is null or

Line 4130: from ben_cm_typ_usg_f ctu

4126: --
4127: cursor c1 is
4128: select ctu.cm_typ_usg_id,
4129: ctu.cm_usg_rl
4130: from ben_cm_typ_usg_f ctu
4131: where ctu.business_group_id = p_business_group_id
4132: and (p_ler_id is null or
4133: nvl(ctu.ler_id,p_ler_id) = p_ler_id)
4134: and (p_pgm_id is null or