DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 504: from ben_prtt_enrt_ctfn_prvdd_f a

500: Cursor c1 is
501: Select a.prtt_enrt_rslt_id,
502: b.actn_typ_id,
503: a.enrt_ctfn_recd_dt
504: from ben_prtt_enrt_ctfn_prvdd_f a
505: ,ben_prtt_enrt_actn_f b
506: ,ben_per_in_ler pil
507: where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
508: and a.business_group_id= p_business_group_Id

Line 749: from ben_prtt_enrt_ctfn_prvdd_f pcf,

745: effective_start_date,
746: effective_end_date,
747: hrl.MEANING,
748: 'Participant certification: ' type
749: from ben_prtt_enrt_ctfn_prvdd_f pcf,
750: hr_lookups hrl
751: where pcf.prtt_enrt_actn_id = c_prtt_enrt_actn_id
752: and pcf.business_group_id = p_business_group_id
753: and p_effective_date between pcf.effective_start_date