APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_PRTT_ENRT_ACTN_F

Line 1104: and pea.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD'

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

Line 1112: ben_prtt_enrt_actn_f pea

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

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

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' ;
1232: --
1233: hr_utility.set_location ('Leaving '||l_proc,10);
1234: --
1235: end restore_cert_completion ;

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

1630: --
1631: -- BEN_PER_IN_LER (PIL)
1632: -- BEN_PRTT_ENRT_RSLT_F (PEN)
1633: -- BEN_PL_BNF_F (PBN) (join to pil to check status)
1634: -- BEN_PRTT_ENRT_ACTN_F (PEA) (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)

Line 2439: from ben_prtt_enrt_actn_f pea,

2435: p_business_group_id in number) is
2436: --
2437: cursor c_get_past_pil (p_per_in_ler_id number) is
2438: select max(pea.per_in_ler_id)
2439: from ben_prtt_enrt_actn_f pea,
2440: ben_per_in_ler pil
2441: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2442: and pea.per_in_ler_id <> p_per_in_ler_id
2443: and pea.business_group_id = p_business_group_id

Line 2451: FROM ben_prtt_enrt_actn_f

2447: CURSOR c_actn_item_for_past_pil (p_per_in_ler_id NUMBER)
2448: IS
2449: SELECT prtt_enrt_actn_id, effective_start_date,
2450: object_version_number
2451: FROM ben_prtt_enrt_actn_f
2452: WHERE per_in_ler_id = p_per_in_ler_id
2453: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2454: AND effective_end_date < hr_api.g_eot
2455: AND business_group_id = p_business_group_id

Line 2458: FROM ben_prtt_enrt_actn_f

2454: AND effective_end_date < hr_api.g_eot
2455: AND business_group_id = p_business_group_id
2456: AND prtt_enrt_actn_id not in
2457: (SELECT prtt_enrt_actn_id
2458: FROM ben_prtt_enrt_actn_f
2459: WHERE per_in_ler_id = p_per_in_ler_id
2460: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2461: AND cmpltd_dt IS NOT NULL)
2462: ORDER BY prtt_enrt_actn_id;