APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_LE_CLSN_N_RSTR

Line 463: from ben_le_clsn_n_rstr

459: --
460: cursor c_prtt_rt_val_adj (p_per_in_ler_id number,
461: p_prtt_rt_val_id number) is
462: select null
463: from ben_le_clsn_n_rstr
464: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
465: AND BKUP_TBL_ID = p_prtt_rt_val_id
466: AND PER_IN_LER_ID = p_per_in_ler_id;
467: --

Line 473: from ben_le_clsn_n_rstr

469: --
470: cursor c_prtt_enrt_rslt_adj (p_per_in_ler_id number,
471: p_prtt_enrt_rslt_id number) is
472: select null
473: from ben_le_clsn_n_rstr
474: where BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'
475: AND BKUP_TBL_ID = p_prtt_enrt_rslt_id
476: AND PER_IN_LER_ID = p_per_in_ler_id;
477: --

Line 530: insert into BEN_LE_CLSN_N_RSTR (

526: THEN
527: hr_utility.set_location ( 'Eligible for pen_id '|| l_ended_result.prtt_enrt_rslt_id,121);
528: END IF;
529:
530: insert into BEN_LE_CLSN_N_RSTR (
531: BKUP_TBL_TYP_CD,
532: COMP_LVL_CD,
533: LCR_ATTRIBUTE16,
534: LCR_ATTRIBUTE17,

Line 701: insert into BEN_LE_CLSN_N_RSTR (

697: l_ended_result.oipl_id,
698: l_ended_result.pl_typ_id,
699: l_ended_result.business_group_id) loop
700:
701: insert into BEN_LE_CLSN_N_RSTR (
702: BKUP_TBL_TYP_CD,
703: COMP_LVL_CD,
704: LCR_ATTRIBUTE16,
705: LCR_ATTRIBUTE17,

Line 973: insert into BEN_LE_CLSN_N_RSTR (

969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);
970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);
971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);
972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);
973: insert into BEN_LE_CLSN_N_RSTR (
974: BKUP_TBL_TYP_CD,
975: COMP_LVL_CD,
976: LCR_ATTRIBUTE16,
977: LCR_ATTRIBUTE17,

Line 1144: insert into BEN_LE_CLSN_N_RSTR (

1140: ,l_ended_result2.per_in_ler_id) loop
1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);
1142: hr_utility.set_location ('l_prv_rec.ended_per_in_ler_id'||l_prv_rec.ended_per_in_ler_id,102);
1143: hr_utility.set_location ('p_per_in_ler_id'||p_per_in_ler_id,102);
1144: insert into BEN_LE_CLSN_N_RSTR (
1145: BKUP_TBL_TYP_CD,
1146: RT_END_DT,
1147: PER_IN_LER_ID,
1148: PER_IN_LER_ENDED_ID,

Line 1173: insert into BEN_LE_CLSN_N_RSTR (

1169: ,l_ended_result2.pl_typ_id
1170: ,l_ended_result2.business_group_id
1171: ) loop
1172:
1173: insert into BEN_LE_CLSN_N_RSTR (
1174: BKUP_TBL_TYP_CD,
1175: COMP_LVL_CD,
1176: LCR_ATTRIBUTE16,
1177: LCR_ATTRIBUTE17,

Line 1430: insert into BEN_LE_CLSN_N_RSTR (

1426: --
1427: open c_prtt_rt_val_adj(p_per_in_ler_id,l_pen.prtt_rt_val_id);
1428: fetch c_prtt_rt_val_adj into l_exists;
1429: if c_prtt_rt_val_adj%notfound then
1430: insert into BEN_LE_CLSN_N_RSTR (
1431: BKUP_TBL_TYP_CD,
1432: BKUP_TBL_ID,
1433: per_in_ler_id,
1434: person_id,

Line 1493: insert into BEN_LE_CLSN_N_RSTR (

1489: --
1490: open c_prtt_enrt_rslt_adj(p_per_in_ler_id,l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id);
1491: fetch c_prtt_enrt_rslt_adj into l_exists;
1492: if c_prtt_enrt_rslt_adj%notfound then
1493: insert into BEN_LE_CLSN_N_RSTR (
1494: BKUP_TBL_TYP_CD,
1495: BKUP_TBL_ID,
1496: per_in_ler_id,
1497: person_id,