APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PRTT_ENRT_RSLT_F

Line 4528: ben_prtt_enrt_rslt_f pen

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

Line 4634: from ben_prtt_enrt_rslt_f pen

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

Line 4750: from ben_prtt_enrt_rslt_f pen

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

Line 4890: ben_prtt_enrt_rslt_f pen

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

Line 5460: from ben_prtt_enrt_rslt_f pen

5456: l_dummy varchar2(1);
5457: --
5458: cursor c1 is
5459: select null
5460: from ben_prtt_enrt_rslt_f pen
5461: where pen.business_group_id = p_business_group_id
5462: and pen.oipl_id = p_oipl_id
5463: and pen.person_id = p_person_id
5464: and l_date_to_use

Line 5767: from ben_prtt_enrt_rslt_f pen

5763: l_dummy varchar2(1);
5764: --
5765: cursor c1(p_plip_id in number) is
5766: select null
5767: from ben_prtt_enrt_rslt_f pen
5768: ,ben_plip_f cpp
5769: where pen.business_group_id = p_business_group_id
5770: and pen.pgm_id = cpp.pgm_id
5771: and pen.pl_id = cpp.pl_id