APPS.BEN_EEV_LER dependencies on BEN_LER

Line 32: from ben_ler ler

28: cursor get_ler(l_status varchar2) is
29: select ler.ler_id,
30: ler.typ_cd ,
31: ler.ocrd_dt_det_cd
32: from ben_ler ler
33: where ler.business_group_id = l_business_group_id
34: and l_session_date between ler.effective_start_date
35: and ler.effective_end_date -- For Bug 3299709
36: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 40: ,ben_ler_per_info_cs_ler lpl

36: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
37: and exists
38: (select 1
39: from ben_per_info_chg_cs_ler_f psl
40: ,ben_ler_per_info_cs_ler lpl
41: where source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
42: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
43: and lpl.business_group_id = psl.business_group_id
44: and lpl.business_group_id = ler.business_group_id

Line 53: ben_ler_rltd_per_cs_ler lrp

49: and lpl.ler_id = ler.ler_id)
50: OR
51: exists (select 1 from
52: ben_rltd_per_chg_cs_ler_f rpc,
53: ben_ler_rltd_per_cs_ler lrp
54: where source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
55: and lrp.business_group_id = rpc.business_group_id
56: and lrp.business_group_id = ler.business_group_id
57: and l_session_date between rpc.effective_start_date

Line 67: from ben_ler_per_info_cs_ler lpl, ben_per_info_chg_cs_ler_f psl

63: order by ler.ler_id;
64: --
65: cursor get_ler_col(p_ler_id IN NUMBER) is
66: select psl.source_column, psl.new_val, psl.old_val, 'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, lpl.chg_mandatory_cd
67: from ben_ler_per_info_cs_ler lpl, ben_per_info_chg_cs_ler_f psl
68: where lpl.ler_id = p_ler_id and
69: lpl.business_group_id = l_business_group_id
70: and lpl.business_group_id = psl.business_group_id
71: and l_session_date between psl.effective_start_date

Line 77: from ben_ler_rltd_per_cs_ler lrp, ben_rltd_per_chg_cs_ler_f rpc

73: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
74: and source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
75: UNION
76: select rpc.source_column, rpc.new_val, rpc.old_val, 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
77: from ben_ler_rltd_per_cs_ler lrp, ben_rltd_per_chg_cs_ler_f rpc
78: where lrp.ler_id = p_ler_id and
79: lrp.business_group_id = l_business_group_id
80: and lrp.business_group_id = rpc.business_group_id
81: and l_session_date between rpc.effective_start_date

Line 108: l_typ_cd ben_ler_f.typ_cd%type ;

104: order by person_id;
105: --
106: l_changed BOOLEAN;
107: l_ler_id NUMBER;
108: l_typ_cd ben_ler_f.typ_cd%type ;
109: l_ocrd_dt_cd VARCHAR2(30);
110: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
111: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
112: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);