APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_PRTT_ENRT_RSLT_F

Line 663: from ben_prtt_enrt_rslt_f pen

659: ,pen.sspndd_flag
660: ,pen.object_version_number
661: ,pen.per_in_ler_id
662: ,'N' skip
663: from ben_prtt_enrt_rslt_f pen
664: where pen.person_id = p_person_id
665: and pen.business_group_id = p_business_group_id
666: and pen.prtt_enrt_rslt_stat_cd is null
667: and exists (select null

Line 677: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result

673: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
674: and p_effective_date between pen.effective_start_date
675: and pen.effective_end_date -1
676: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840
677: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result
678: where pen1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
679: and pen1.effective_end_date = hr_api.g_eot
680: and pen1.enrt_cvg_thru_dt <> hr_api.g_eot
681: )

Line 1731: from ben_prtt_enrt_rslt_f pen

1727: --
1728: cursor c_pen
1729: is
1730: select distinct pen.person_id
1731: from ben_prtt_enrt_rslt_f pen
1732: ,ben_per_in_ler pil
1733: ,ben_prtt_enrt_actn_f actn
1734: where pen.business_group_id = p_business_group_id
1735: and pen.business_group_id = actn.business_group_id