APPS.BEN_CVRD_DPNT_CTFN_PRVDD_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 25: from ben_prtt_enrt_rslt_f pen,

21: pea.actn_typ_id,
22: pea.cmpltd_dt,
23: pen.object_version_number rslt_ovn,
24: pea.object_version_number
25: from ben_prtt_enrt_rslt_f pen,
26: ben_prtt_enrt_actn_f pea,
27: ben_elig_cvrd_dpnt_f pdp
28: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
29: and pea.elig_cvrd_dpnt_id = pdp.elig_cvrd_dpnt_id

Line 147: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;

143: l_effective_end_date ben_cvrd_dpnt_ctfn_prvdd_f.effective_end_date%TYPE;
144: l_proc varchar2(72) := g_package||'create_CVRD_DPNT_CTFN_PRVDD';
145: l_object_version_number ben_cvrd_dpnt_ctfn_prvdd_f.object_version_number%TYPE;
146: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
147: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
148: --
149: cursor c_pdp is
150: select pdp.prtt_enrt_rslt_id
151: from ben_elig_cvrd_dpnt_f pdp

Line 797: ben_prtt_enrt_rslt_f pen

793: select pea.object_version_number,
794: pea.prtt_enrt_rslt_id,
795: pen.object_version_number
796: from ben_prtt_enrt_actn_f pea,
797: ben_prtt_enrt_rslt_f pen
798: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
799: and pea.business_group_id = p_business_group_id
800: and pen.prtt_enrt_rslt_stat_cd is null
801: and p_effective_date between pea.effective_start_date

Line 1041: ben_prtt_enrt_rslt_f pen

1037: select pea.object_version_number,
1038: pea.prtt_enrt_rslt_id,
1039: pen.object_version_number
1040: from ben_prtt_enrt_actn_f pea,
1041: ben_prtt_enrt_rslt_f pen
1042: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
1043: and pea.business_group_id = p_business_group_id
1044: and pen.prtt_enrt_rslt_stat_cd is null
1045: and p_effective_date between pea.effective_start_date