APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 5867: from ben_prtt_enrt_ctfn_prvdd_f pcs,

5863: l_proc varchar2(72) := g_package || '.reinstate_pcs_per_pen';
5864: --
5865: cursor c_old_pcs is
5866: select pcs.*, pea.ACTN_TYP_ID
5867: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5868: ben_prtt_enrt_actn_f pea
5869: where pcs.prtt_enrt_actn_id = pea.prtt_enrt_actn_id
5870: and pcs.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5871: and pea.per_in_ler_id = p_bckdt_per_in_ler_id

Line 5884: from ben_prtt_enrt_ctfn_prvdd_f pcs,

5880: Added union condition to get the latest certification record(if records exists in update mode) while
5881: reinstating the certification record.*/
5882: union
5883: select pcs.*, pea.ACTN_TYP_ID
5884: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5885: ben_prtt_enrt_actn_f pea
5886: where pcs.prtt_enrt_actn_id = pea.prtt_enrt_actn_id
5887: and pcs.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5888: and pea.per_in_ler_id = p_bckdt_per_in_ler_id

Line 5895: and pcs.effective_start_date = (select max(effective_start_date) from ben_prtt_enrt_ctfn_prvdd_f pcs1

5891: and pea.effective_start_date = (select max(effective_start_date) from ben_prtt_enrt_actn_f pea1
5892: where pea1.per_in_ler_id = pea.per_in_ler_id
5893: and pea1.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
5894: and pea1.prtt_enrt_actn_id = pea.prtt_enrt_actn_id)
5895: and pcs.effective_start_date = (select max(effective_start_date) from ben_prtt_enrt_ctfn_prvdd_f pcs1
5896: where pcs1.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id
5897: and pcs1.prtt_enrt_actn_id = pcs.prtt_enrt_actn_id);
5898: --
5899: l_pcs_effective_start_date date;

Line 5907: from ben_prtt_enrt_ctfn_prvdd_f pcs,

5903: cursor c_pcs(cp_enrt_ctfn_typ_cd in varchar2,
5904: cp_ENRT_R_BNFT_CTFN_CD in varchar2,
5905: cp_ACTN_TYP_ID in varchar2) is
5906: select pcs.*
5907: from ben_prtt_enrt_ctfn_prvdd_f pcs,
5908: ben_prtt_enrt_actn_f pea
5909: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5910: and nvl(pcs.enrt_ctfn_typ_cd, -1) = nvl(cp_enrt_ctfn_typ_cd, -1)
5911: and nvl(pcs.enrt_r_bnft_ctfn_cd, -1) = nvl(cp_enrt_r_bnft_ctfn_cd, -1)