APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_LE_CLSN_N_RSTR

Line 932: insert into BEN_LE_CLSN_N_RSTR (

928: --ben_prtt_enrt_actn_f
929: --
930: for l_pea in c_future_pea(l_bnf_types.prtt_enrt_actn_id,l_effective_date) loop
931: --
932: insert into BEN_LE_CLSN_N_RSTR (
933: BKUP_TBL_TYP_CD,
934: BKUP_TBL_ID,
935: EFFECTIVE_START_DATE,
936: EFFECTIVE_END_DATE,

Line 1052: insert into BEN_LE_CLSN_N_RSTR (

1048: --ben_prtt_enrt_ctfn_prvdd_f
1049: --
1050: for l_lcs in c_future_pcs(l_bnf_types.prtt_enrt_actn_id,l_effective_date) loop
1051: --
1052: insert into BEN_LE_CLSN_N_RSTR (
1053: BKUP_TBL_TYP_CD,
1054: BKUP_TBL_ID,
1055: EFFECTIVE_START_DATE,
1056: EFFECTIVE_END_DATE,

Line 3970: insert into BEN_LE_CLSN_N_RSTR (

3966: l_count := l_count + 1;
3967: hr_utility.set_location('c_ppe1 found',1);
3968: hr_utility.set_location('l_ppe1.prtt_prem_id : '||l_ppe1.prtt_prem_id,1);
3969: ---bkup table
3970: insert into BEN_LE_CLSN_N_RSTR (
3971: BKUP_TBL_TYP_CD,
3972: LCR_ATTRIBUTE6,
3973: LCR_ATTRIBUTE7,
3974: LCR_ATTRIBUTE8,

Line 4601: from BEN_LE_CLSN_N_RSTR

4597: c_cvg_strt_dt date ,
4598: c_cvg_thru_dt date ,
4599: c_pen_stat_cd varchar2 ) is
4600: select 'x'
4601: from BEN_LE_CLSN_N_RSTR
4602: where bkup_tbl_id = c_pen_id
4603: and ((per_in_ler_id = c_pil_id
4604: and per_in_ler_ended_id = c_pil_end_id)
4605: or (per_in_ler_ended_id = c_pil_id -- 8972844

Line 4610: from BEN_LE_CLSN_N_RSTR

4606: and per_in_ler_id = c_pil_end_id)) -- 7197868
4607: and BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
4608: union
4609: select 'x'
4610: from BEN_LE_CLSN_N_RSTR
4611: where bkup_tbl_id = c_pen_id
4612: and per_in_ler_id = c_pil_id
4613: and BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F'
4614: and c_eff_strt_dt = EFFECTIVE_START_DATE

Line 4705: insert into BEN_LE_CLSN_N_RSTR (

4701: fetch c_bckup_tbl_restore into l_dummy ;
4702: if c_bckup_tbl_restore%notfound then
4703: hr_utility.set_location(' backup row not found ' || p_prtt_enrt_rslt_id , 99 );
4704:
4705: insert into BEN_LE_CLSN_N_RSTR (
4706: BKUP_TBL_TYP_CD,
4707: COMP_LVL_CD,
4708: LCR_ATTRIBUTE16,
4709: LCR_ATTRIBUTE17,

Line 6697: from ben_prtt_enrt_rslt_f pen, ben_le_clsn_n_rstr cls

6693: -- Bug 6165501 : Added union clause if its a Correction case, and interim has already
6694: -- been end-dated by the new pil, then no need to call delete_enrollment for the interim
6695: UNION
6696: select 'Y'
6697: from ben_prtt_enrt_rslt_f pen, ben_le_clsn_n_rstr cls
6698: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6699: and pen.prtt_enrt_rslt_stat_cd is null
6700: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
6701: and pen.per_in_ler_id = p_per_in_ler_id

Line 6895: from BEN_LE_CLSN_N_RSTR

6891: cursor c_old_corr_pen (c_pil_id number
6892: ,c_pen_id number
6893: ,c_pen_effective_start_date date) is -- bug 7197868
6894: select per_in_ler_id
6895: from BEN_LE_CLSN_N_RSTR
6896: where bkup_tbl_id = c_pen_id
6897: and per_in_ler_ended_id = c_pil_id
6898: and per_in_ler_id <> c_pil_id
6899: and effective_start_date = c_pen_effective_start_date -- bug 7197868

Line 6901: l_corr_pil_id BEN_LE_CLSN_N_RSTR.per_in_ler_id%type ;

6897: and per_in_ler_ended_id = c_pil_id
6898: and per_in_ler_id <> c_pil_id
6899: and effective_start_date = c_pen_effective_start_date -- bug 7197868
6900: and enrt_cvg_thru_dt = hr_api.g_eot;
6901: l_corr_pil_id BEN_LE_CLSN_N_RSTR.per_in_ler_id%type ;
6902:
6903: cursor c_pen_obj_no (c_pil_id number
6904: ,c_pen_id number ) is
6905: select object_version_number

Line 7074: FROM ben_le_clsn_n_rstr bcr

7070: ,cp_per_in_ler_id NUMBER
7071: ,cp_person_id NUMBER --12566240
7072: ) IS
7073: SELECT 'X' place_holder
7074: FROM ben_le_clsn_n_rstr bcr
7075: WHERE bcr.bkup_tbl_id=cp_prtt_enrt_rslt_id
7076: AND bcr.effective_start_date=cp_effective_date
7077: AND bcr.person_id = cp_person_id -- Bug 12356840
7078: UNION

Line 7080: FROM ben_le_clsn_n_rstr bcr

7076: AND bcr.effective_start_date=cp_effective_date
7077: AND bcr.person_id = cp_person_id -- Bug 12356840
7078: UNION
7079: SELECT 'X' place_holder
7080: FROM ben_le_clsn_n_rstr bcr
7081: WHERE bcr.bkup_tbl_id=cp_prtt_enrt_rslt_id
7082: AND bcr.per_in_ler_id <> cp_per_in_ler_id
7083: AND bcr.person_id = cp_person_id -- Bug 12356840
7084: --AND bcr.bkup_tbl_typ_cd LIKE '%CORR' -- Bug 12356840

Line 10552: update ben_le_clsn_n_rstr

10548: /* -- added here for bug 6963660
10549: -- updated the corrected result in the back up table so that it behaves as
10550: -- if corrected on the p_effective_start_date
10551: --
10552: update ben_le_clsn_n_rstr
10553: set effective_start_date = p_effective_start_date
10554: where per_in_ler_id = l_corr_pil_id
10555: and bkup_tbl_id = p_prtt_enrt_rslt_id
10556: and bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F_CORR';