APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_ELIG_CVRD_DPNT_F

Line 4474: from ben_elig_cvrd_dpnt_f pdp,

4470: l_dummy varchar2(1);
4471: --
4472: cursor c1(p_pl_id in number) is
4473: select null
4474: from ben_elig_cvrd_dpnt_f pdp,
4475: ben_prtt_enrt_rslt_f pen
4476: where pen.business_group_id = p_business_group_id
4477: and pen.pl_id = p_pl_id
4478: and pdp.dpnt_person_id = p_person_id

Line 4582: ,ben_elig_cvrd_dpnt_f pdp

4578: --
4579: cursor c1(p_plip_id in number) is
4580: select null
4581: from ben_prtt_enrt_rslt_f pen
4582: ,ben_elig_cvrd_dpnt_f pdp
4583: ,ben_plip_f cpp
4584: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
4585: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
4586: and pen.prtt_enrt_rslt_stat_cd is null

Line 4698: ,ben_elig_cvrd_dpnt_f pdp

4694: --
4695: cursor c1(p_ptip_id in number) is
4696: select pen.pl_id
4697: from ben_prtt_enrt_rslt_f pen
4698: ,ben_elig_cvrd_dpnt_f pdp
4699: where pen.prtt_enrt_rslt_id = pdp.prtt_enrt_rslt_id
4700: --and pen.prtt_enrt_rslt_stat_cd not in ('BCKDT', 'VOIDD')
4701: and pen.prtt_enrt_rslt_stat_cd is null
4702: and pdp.dpnt_person_id = p_person_id

Line 4836: from ben_elig_cvrd_dpnt_f pdp,

4832: l_dummy varchar2(1);
4833: --
4834: cursor c1(p_pgm_id in number) is
4835: select null
4836: from ben_elig_cvrd_dpnt_f pdp,
4837: ben_prtt_enrt_rslt_f pen
4838: where pen.business_group_id = p_business_group_id
4839: and pen.pgm_id = p_pgm_id
4840: and pdp.dpnt_person_id = p_person_id