APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PRTT_ENRT_RSLT_F

Line 4475: ben_prtt_enrt_rslt_f pen

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
4479: and l_date_to_use

Line 4581: from ben_prtt_enrt_rslt_f pen

4577: l_dummy varchar2(1);
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')

Line 4697: from ben_prtt_enrt_rslt_f pen

4693: l_dummy varchar2(1);
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

Line 4837: ben_prtt_enrt_rslt_f pen

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
4841: and l_date_to_use

Line 5403: from ben_prtt_enrt_rslt_f pen

5399: l_dummy varchar2(1);
5400: --
5401: cursor c1 is
5402: select null
5403: from ben_prtt_enrt_rslt_f pen
5404: where pen.business_group_id = p_business_group_id
5405: and pen.oipl_id = p_oipl_id
5406: and pen.person_id = p_person_id
5407: and l_date_to_use

Line 5710: from ben_prtt_enrt_rslt_f pen

5706: l_dummy varchar2(1);
5707: --
5708: cursor c1(p_plip_id in number) is
5709: select null
5710: from ben_prtt_enrt_rslt_f pen
5711: ,ben_plip_f cpp
5712: where pen.business_group_id = p_business_group_id
5713: and pen.pgm_id = cpp.pgm_id
5714: and pen.pl_id = cpp.pl_id