APPS.BEN_EGD_LER dependencies on BEN_LER_F

Line 28: FROM ben_ler_f ler

24: --
25: cursor get_ler(l_status varchar2) is
26: SELECT ler.ler_id,
27: ler.ocrd_dt_det_cd
28: FROM ben_ler_f ler
29: WHERE ler.business_group_id = p_new.business_group_id
30: AND l_session_date BETWEEN ler.effective_start_date
31: AND ler.effective_end_date
32: AND (

Line 64: CURSOR get_ler_col(p_ler_id IN ben_ler_f.ler_id%TYPE) IS

60: )
61: );
62: --
63:
64: CURSOR get_ler_col(p_ler_id IN ben_ler_f.ler_id%TYPE) IS
65: SELECT psl.source_column,
66: psl.new_val,
67: psl.old_val,
68: 'P',

Line 100: p_ler_id IN ben_ler_f.ler_id%TYPE,

96: order by 1;
97: --
98: CURSOR le_exists(
99: p_person_id IN per_all_people_f.person_id%TYPE,
100: p_ler_id IN ben_ler_f.ler_id%TYPE,
101: p_lf_evt_ocrd_dt IN DATE) IS
102: SELECT 'Y'
103: FROM ben_ptnl_ler_for_per bp
104: WHERE bp.person_id = p_person_id

Line 131: l_typ_cd ben_ler_f.typ_cd%type ;

127: --End Bug 5630251
128: --
129: l_changed BOOLEAN;
130: l_ler_id NUMBER;
131: l_typ_cd ben_ler_f.typ_cd%type ;
132: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
133: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
134: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
135: l_ocrd_dt_cd VARCHAR2(30);

Line 161: l_rec_business_group_id ben_ler_f.business_group_id%TYPE

157: l_chg_mandatory_cd VARCHAR2(1);
158: l_trigger boolean := TRUE;
159: --
160: --
161: l_rec_business_group_id ben_ler_f.business_group_id%TYPE
162: := NVL(p_new.business_group_id, p_old.business_group_id);
163: l_rec_dpnt_person_id per_all_people_f.person_id%TYPE
164: := NVL(p_new.dpnt_person_id, p_old.dpnt_person_id);
165: