APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 863: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'

859: ben_le_clsn_n_rstr pea
860: where pcs.per_in_ler_ended_id = p_pil_id
861: and pea.per_in_ler_ended_id = p_pil_id
862: and pea.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD'
863: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'
864: and pea.BKUP_TBL_ID = pcs.PGM_ID ; --PRTT_ENRT_ACTN_ID
865: --
866: cursor c_pcs(p_prtt_enrt_ctfn_prvdd_id number,
867: p_effective_date date ) IS

Line 869: from ben_prtt_enrt_ctfn_prvdd_f pcs,

865: --
866: cursor c_pcs(p_prtt_enrt_ctfn_prvdd_id number,
867: p_effective_date date ) IS
868: select pcs.object_version_number
869: from ben_prtt_enrt_ctfn_prvdd_f pcs,
870: ben_prtt_enrt_actn_f pea
871: where pcs.prtt_enrt_ctfn_prvdd_id = p_prtt_enrt_ctfn_prvdd_id
872: and pea.prtt_enrt_actn_id = pcs.prtt_enrt_actn_id
873: and p_effective_date between pcs.effective_start_date

Line 900: p_base_table_name => 'BEN_PRTT_ENRT_CTFN_PRVDD_F',

896: IF c_pcs%FOUND THEN
897: --Get the Datetrack Mode
898: dt_api.find_dt_upd_modes
899: (p_effective_date => l_effective_date,
900: p_base_table_name => 'BEN_PRTT_ENRT_CTFN_PRVDD_F',
901: p_base_key_column => 'PRTT_ENRT_CTFN_PRVDD_ID',
902: p_base_key_value => l_rec.BKUP_TBL_ID,
903: p_correction => l_correction,
904: p_update => l_update,

Line 985: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD' ;

981: --Now Delete the records from ben_le_clsn_n_rstr
982: --
983: delete from ben_le_clsn_n_rstr pcs
984: where pcs.per_in_ler_ended_id = p_per_in_ler_id
985: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD' ;
986: --
987: delete from ben_le_clsn_n_rstr pcs
988: where pcs.per_in_ler_ended_id = p_per_in_ler_id
989: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD' ;

Line 1291: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)

1287: -- BEN_BNFT_PRVDD_LDGR_F (BPL)(join to pil to check status)
1288: -- BEN_PRTT_RT_VAL (PRV)
1289: -- BEN_PRTT_REIMBMT_RQST_F
1290: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1291: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)
1292: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1293: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1294: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1295: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)

Line 2082: from ben_prtt_enrt_ctfn_prvdd_f

2078: l_actn_item c_actn_item_for_past_pil%rowtype;
2079: --
2080: cursor c_enrt_ctfn_for_past_pil (p_prtt_enrt_actn_id number) is
2081: select prtt_enrt_ctfn_prvdd_id, effective_start_date, object_version_number
2082: from ben_prtt_enrt_ctfn_prvdd_f
2083: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2084: and prtt_enrt_actn_id = p_prtt_enrt_actn_id
2085: and effective_end_date < hr_api.g_eot
2086: and business_group_id = p_business_group_id;