APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_ELIG_CVRD_DPNT_F

Line 4527: from ben_elig_cvrd_dpnt_f pdp,

4523: l_dummy varchar2(1);
4524: --
4525: cursor c1(p_pl_id in number) is
4526: select null
4527: from ben_elig_cvrd_dpnt_f pdp,
4528: ben_prtt_enrt_rslt_f pen
4529: where pen.business_group_id = p_business_group_id
4530: and pen.pl_id = p_pl_id
4531: and pdp.dpnt_person_id = p_person_id

Line 4635: ,ben_elig_cvrd_dpnt_f pdp

4631: --
4632: cursor c1(p_plip_id in number) is
4633: select null
4634: from ben_prtt_enrt_rslt_f pen
4635: ,ben_elig_cvrd_dpnt_f pdp
4636: ,ben_plip_f cpp
4637: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
4638: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
4639: and pen.prtt_enrt_rslt_stat_cd is null

Line 4751: ,ben_elig_cvrd_dpnt_f pdp

4747: --
4748: cursor c1(p_ptip_id in number) is
4749: select pen.pl_id
4750: from ben_prtt_enrt_rslt_f pen
4751: ,ben_elig_cvrd_dpnt_f pdp
4752: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
4753: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
4754: and pen.prtt_enrt_rslt_stat_cd is null
4755: and pdp.dpnt_person_id = p_person_id

Line 4889: from ben_elig_cvrd_dpnt_f pdp,

4885: l_dummy varchar2(1);
4886: --
4887: cursor c1(p_pgm_id in number) is
4888: select null
4889: from ben_elig_cvrd_dpnt_f pdp,
4890: ben_prtt_enrt_rslt_f pen
4891: where pen.business_group_id = p_business_group_id
4892: and pen.pgm_id = p_pgm_id
4893: and pdp.dpnt_person_id = p_person_id