APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_ELIG_CVRD_DPNT_F

Line 6504: from ben_elig_cvrd_dpnt_f pdp,

6500: l_dummy varchar2(1);
6501: --
6502: cursor c1(p_pl_id in number) is
6503: select null
6504: from ben_elig_cvrd_dpnt_f pdp,
6505: ben_prtt_enrt_rslt_f pen
6506: where pen.business_group_id = p_business_group_id
6507: and pen.pl_id = p_pl_id
6508: and pdp.dpnt_person_id = p_person_id

Line 6744: ,ben_elig_cvrd_dpnt_f pdp

6740: --
6741: cursor c1(p_plip_id in number,p_date_to_use date ) is
6742: select null
6743: from ben_prtt_enrt_rslt_f pen
6744: ,ben_elig_cvrd_dpnt_f pdp
6745: ,ben_plip_f cpp
6746: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
6747: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
6748: and pen.prtt_enrt_rslt_stat_cd is null

Line 7066: ,ben_elig_cvrd_dpnt_f pdp

7062: --
7063: cursor c1(p_ptip_id in number,p_date_to_use date ) is
7064: select pen.pl_id
7065: from ben_prtt_enrt_rslt_f pen
7066: ,ben_elig_cvrd_dpnt_f pdp
7067: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
7068: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
7069: and pen.prtt_enrt_rslt_stat_cd is null
7070: and pdp.dpnt_person_id = p_person_id

Line 7218: from ben_elig_cvrd_dpnt_f pdp,

7214: l_dummy varchar2(1);
7215: --
7216: cursor c1(p_pgm_id in number) is
7217: select null
7218: from ben_elig_cvrd_dpnt_f pdp,
7219: ben_prtt_enrt_rslt_f pen
7220: where pen.business_group_id = p_business_group_id
7221: and pen.pgm_id = p_pgm_id
7222: and pdp.dpnt_person_id = p_person_id