APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 1105: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'

1101: ben_le_clsn_n_rstr pea
1102: where pcs.per_in_ler_ended_id = p_pil_id
1103: and pea.per_in_ler_ended_id = p_pil_id
1104: and pea.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD'
1105: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'
1106: and pea.BKUP_TBL_ID = pcs.PGM_ID ; --PRTT_ENRT_ACTN_ID
1107: --
1108: cursor c_pcs(p_prtt_enrt_ctfn_prvdd_id number,
1109: p_effective_date date ) IS

Line 1111: from ben_prtt_enrt_ctfn_prvdd_f pcs,

1107: --
1108: cursor c_pcs(p_prtt_enrt_ctfn_prvdd_id number,
1109: p_effective_date date ) IS
1110: select pcs.object_version_number
1111: from ben_prtt_enrt_ctfn_prvdd_f pcs,
1112: ben_prtt_enrt_actn_f pea
1113: where pcs.prtt_enrt_ctfn_prvdd_id = p_prtt_enrt_ctfn_prvdd_id
1114: and pea.prtt_enrt_actn_id = pcs.prtt_enrt_actn_id
1115: and p_effective_date between pcs.effective_start_date

Line 1142: p_base_table_name => 'BEN_PRTT_ENRT_CTFN_PRVDD_F',

1138: IF c_pcs%FOUND THEN
1139: --Get the Datetrack Mode
1140: dt_api.find_dt_upd_modes
1141: (p_effective_date => l_effective_date,
1142: p_base_table_name => 'BEN_PRTT_ENRT_CTFN_PRVDD_F',
1143: p_base_key_column => 'PRTT_ENRT_CTFN_PRVDD_ID',
1144: p_base_key_value => l_rec.BKUP_TBL_ID,
1145: p_correction => l_correction,
1146: p_update => l_update,

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

1223: --Now Delete the records from ben_le_clsn_n_rstr
1224: --
1225: delete from ben_le_clsn_n_rstr pcs
1226: where pcs.per_in_ler_ended_id = p_per_in_ler_id
1227: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD' ;
1228: --
1229: delete from ben_le_clsn_n_rstr pcs
1230: where pcs.per_in_ler_ended_id = p_per_in_ler_id
1231: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD' ;

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

1635: -- BEN_BNFT_PRVDD_LDGR_F (BPL)(join to pil to check status)
1636: -- BEN_PRTT_RT_VAL (PRV)
1637: -- BEN_PRTT_REIMBMT_RQST_F
1638: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1639: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)
1640: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1641: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1642: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1643: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)

Line 2467: from ben_prtt_enrt_ctfn_prvdd_f

2463: l_actn_item c_actn_item_for_past_pil%rowtype;
2464: --
2465: cursor c_enrt_ctfn_for_past_pil (p_prtt_enrt_actn_id number) is
2466: select prtt_enrt_ctfn_prvdd_id, effective_start_date, object_version_number
2467: from ben_prtt_enrt_ctfn_prvdd_f
2468: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2469: and prtt_enrt_actn_id = p_prtt_enrt_actn_id
2470: and effective_end_date < hr_api.g_eot
2471: and business_group_id = p_business_group_id;