APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_ELIG_CVRD_DPNT_F

Line 6516: from ben_elig_cvrd_dpnt_f pdp,

6512: l_dummy varchar2(1);
6513: --
6514: cursor c1(p_pl_id in number) is
6515: select null
6516: from ben_elig_cvrd_dpnt_f pdp,
6517: ben_prtt_enrt_rslt_f pen
6518: where pen.business_group_id = p_business_group_id
6519: and pen.pl_id = p_pl_id
6520: and pdp.dpnt_person_id = p_person_id

Line 6756: ,ben_elig_cvrd_dpnt_f pdp

6752: --
6753: cursor c1(p_plip_id in number,p_date_to_use date ) is
6754: select null
6755: from ben_prtt_enrt_rslt_f pen
6756: ,ben_elig_cvrd_dpnt_f pdp
6757: ,ben_plip_f cpp
6758: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
6759: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
6760: and pen.prtt_enrt_rslt_stat_cd is null

Line 7078: ,ben_elig_cvrd_dpnt_f pdp

7074: --
7075: cursor c1(p_ptip_id in number,p_date_to_use date ) is
7076: select pen.pl_id
7077: from ben_prtt_enrt_rslt_f pen
7078: ,ben_elig_cvrd_dpnt_f pdp
7079: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
7080: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
7081: and pen.prtt_enrt_rslt_stat_cd is null
7082: and pdp.dpnt_person_id = p_person_id

Line 7230: from ben_elig_cvrd_dpnt_f pdp,

7226: l_dummy varchar2(1);
7227: --
7228: cursor c1(p_pgm_id in number) is
7229: select null
7230: from ben_elig_cvrd_dpnt_f pdp,
7231: ben_prtt_enrt_rslt_f pen
7232: where pen.business_group_id = p_business_group_id
7233: and pen.pgm_id = p_pgm_id
7234: and pdp.dpnt_person_id = p_person_id