APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 112: ben_elig_per_elctbl_chc epe

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
115: and ctu.business_group_id = pil.business_group_id
116: /* First join comp objects */

Line 162: from ben_elig_per_elctbl_chc epe,

158: and egd1.elig_cvrd_dpnt_id is not null);
159: --
160: cursor c_dpnt_always is
161: select null
162: from ben_elig_per_elctbl_chc epe,
163: ben_per_in_ler pil
164: where pil.per_in_ler_id = p_per_in_ler_id
165: and pil.business_group_id = p_business_group_id
166: and epe.business_group_id = pil.business_group_id

Line 183: ben_elig_per_elctbl_chc epe

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
186: and ctu.business_group_id = pil.business_group_id
187: /* First join comp objects */

Line 241: from ben_elig_per_elctbl_chc epe,

237: and pen1.effective_end_date);
238: --
239: cursor c_bnf_always is
240: select null
241: from ben_elig_per_elctbl_chc epe,
242: ben_per_in_ler pil
243: where pil.per_in_ler_id = p_per_in_ler_id
244: and pil.business_group_id = p_business_group_id
245: and epe.business_group_id = pil.business_group_id

Line 2258: from ben_elig_per_elctbl_chc epe,

2254: and pdp.effective_end_date);
2255: --
2256: cursor c_dpnt_always is
2257: select null
2258: from ben_elig_per_elctbl_chc epe,
2259: ben_per_in_ler pil
2260: where pil.per_in_ler_id = p_per_in_ler_id
2261: and pil.business_group_id = p_business_group_id
2262: and epe.business_group_id = pil.business_group_id

Line 2300: from ben_elig_per_elctbl_chc epe,

2296: and pbn.effective_start_date = p_effective_date);
2297: --
2298: cursor c_bnf_always is
2299: select null
2300: from ben_elig_per_elctbl_chc epe,
2301: ben_per_in_ler pil
2302: where pil.per_in_ler_id = p_per_in_ler_id
2303: and pil.business_group_id = p_business_group_id
2304: and epe.business_group_id = pil.business_group_id

Line 4379: ben_elig_per_elctbl_chc epe,

4375: --
4376: cursor c_epe is
4377: select 'Y'
4378: from ben_elig_dpnt egd,
4379: ben_elig_per_elctbl_chc epe,
4380: ben_per_in_ler pil,
4381: ben_pl_f pln,
4382: ben_oipl_f cop,
4383: ben_opt_f opt

Line 4500: from ben_elig_per_elctbl_chc epe,

4496: --3585939
4497: cursor c_prtt_epe(v_pgm_id in number,
4498: v_pl_typ_id in number) is
4499: select 'Y'
4500: from ben_elig_per_elctbl_chc epe,
4501: ben_per_in_ler pil,
4502: ben_pl_f pln,
4503: ben_oipl_f cop,
4504: ben_opt_f opt