APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_PRTT_ENRT_ACTN_F

Line 862: and pea.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD'

858: from ben_le_clsn_n_rstr pcs,
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,

Line 870: ben_prtt_enrt_actn_f pea

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
874: and pcs.effective_end_date

Line 989: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD' ;

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' ;
990: --
991: hr_utility.set_location ('Leaving '||l_proc,10);
992: --
993: end restore_cert_completion ;

Line 1286: -- BEN_PRTT_ENRT_ACTN_F (PEA) (join to pil to check status)

1282: --
1283: -- BEN_PER_IN_LER (PIL)
1284: -- BEN_PRTT_ENRT_RSLT_F (PEN)
1285: -- BEN_PL_BNF_F (PBN) (join to pil to check status)
1286: -- BEN_PRTT_ENRT_ACTN_F (PEA) (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)

Line 2054: from ben_prtt_enrt_actn_f pea,

2050: p_business_group_id in number) is
2051: --
2052: cursor c_get_past_pil (p_per_in_ler_id number) is
2053: select max(pea.per_in_ler_id)
2054: from ben_prtt_enrt_actn_f pea,
2055: ben_per_in_ler pil
2056: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2057: and pea.per_in_ler_id <> p_per_in_ler_id
2058: and pea.business_group_id = p_business_group_id

Line 2066: FROM ben_prtt_enrt_actn_f

2062: CURSOR c_actn_item_for_past_pil (p_per_in_ler_id NUMBER)
2063: IS
2064: SELECT prtt_enrt_actn_id, effective_start_date,
2065: object_version_number
2066: FROM ben_prtt_enrt_actn_f
2067: WHERE per_in_ler_id = p_per_in_ler_id
2068: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2069: AND effective_end_date < hr_api.g_eot
2070: AND business_group_id = p_business_group_id

Line 2073: FROM ben_prtt_enrt_actn_f

2069: AND effective_end_date < hr_api.g_eot
2070: AND business_group_id = p_business_group_id
2071: AND prtt_enrt_actn_id not in
2072: (SELECT prtt_enrt_actn_id
2073: FROM ben_prtt_enrt_actn_f
2074: WHERE per_in_ler_id = p_per_in_ler_id
2075: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2076: AND cmpltd_dt IS NOT NULL)
2077: ORDER BY prtt_enrt_actn_id;