APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_LE_CLSN_N_RSTR

Line 425: from ben_le_clsn_n_rstr

421: --
422: cursor c_prtt_rt_val_adj (p_per_in_ler_id number,
423: p_prtt_rt_val_id number) is
424: select null
425: from ben_le_clsn_n_rstr
426: where BKUP_TBL_TYP_CD = 'BEN_PRTT_RT_VAL_ADJ'
427: AND BKUP_TBL_ID = p_prtt_rt_val_id
428: AND PER_IN_LER_ID = p_per_in_ler_id;
429: --

Line 435: from ben_le_clsn_n_rstr

431: --
432: cursor c_prtt_enrt_rslt_adj (p_per_in_ler_id number,
433: p_prtt_enrt_rslt_id number) is
434: select null
435: from ben_le_clsn_n_rstr
436: where BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'
437: AND BKUP_TBL_ID = p_prtt_enrt_rslt_id
438: AND PER_IN_LER_ID = p_per_in_ler_id;
439: --

Line 492: insert into BEN_LE_CLSN_N_RSTR (

488: THEN
489: hr_utility.set_location ( 'Eligible for pen_id '|| l_ended_result.prtt_enrt_rslt_id,121);
490: END IF;
491:
492: insert into BEN_LE_CLSN_N_RSTR (
493: BKUP_TBL_TYP_CD,
494: COMP_LVL_CD,
495: LCR_ATTRIBUTE16,
496: LCR_ATTRIBUTE17,

Line 663: insert into BEN_LE_CLSN_N_RSTR (

659: l_ended_result.oipl_id,
660: l_ended_result.pl_typ_id,
661: l_ended_result.business_group_id) loop
662:
663: insert into BEN_LE_CLSN_N_RSTR (
664: BKUP_TBL_TYP_CD,
665: COMP_LVL_CD,
666: LCR_ATTRIBUTE16,
667: LCR_ATTRIBUTE17,

Line 931: insert into BEN_LE_CLSN_N_RSTR (

927: exit;
928: end if;
929: --
930: hr_utility.set_location ('ENdedn result 2',100);
931: insert into BEN_LE_CLSN_N_RSTR (
932: BKUP_TBL_TYP_CD,
933: COMP_LVL_CD,
934: LCR_ATTRIBUTE16,
935: LCR_ATTRIBUTE17,

Line 1156: insert into BEN_LE_CLSN_N_RSTR (

1152: --
1153: open c_prtt_rt_val_adj(p_per_in_ler_id,l_pen.prtt_rt_val_id);
1154: fetch c_prtt_rt_val_adj into l_exists;
1155: if c_prtt_rt_val_adj%notfound then
1156: insert into BEN_LE_CLSN_N_RSTR (
1157: BKUP_TBL_TYP_CD,
1158: BKUP_TBL_ID,
1159: per_in_ler_id,
1160: person_id,

Line 1219: insert into BEN_LE_CLSN_N_RSTR (

1215: --
1216: open c_prtt_enrt_rslt_adj(p_per_in_ler_id,l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id);
1217: fetch c_prtt_enrt_rslt_adj into l_exists;
1218: if c_prtt_enrt_rslt_adj%notfound then
1219: insert into BEN_LE_CLSN_N_RSTR (
1220: BKUP_TBL_TYP_CD,
1221: BKUP_TBL_ID,
1222: per_in_ler_id,
1223: person_id,