eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVAL_COMM_LER_ELIG_PROFL dependencies on BEN_ELIG_OBJ_ELIG_PROFL_F

Line 14: ben_elig_obj_elig_profl_f

10: elig_obj_elig_prfl_id,
11: elig_prfl_id,
12: object_version_number
13: from
14: ben_elig_obj_elig_profl_f
15: where
16: p_effective_date between effective_start_date and effective_end_date
17: and elig_obj_id = p_elig_obj_id
18: and elig_prfl_id = p_eligibility_profile_id;

Line 33: ben_elig_obj_elig_profl_f obe

29: l_dummy number ;
30: --
31: cursor c_uniq_cm_typ_elig_prfl is
32: select obj.ELIG_OBJ_ID from ben_elig_obj_f obj ,
33: ben_elig_obj_elig_profl_f obe
34: where ((obe.effective_start_date > p_effective_date)
35: OR (p_effective_date BETWEEN obe.effective_start_date AND obe.effective_END_date))
36: and obj.table_name = p_table_name
37: and obj.column_name = p_column_name

Line 101: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;

97: l_effective_start_date date;
98: l_effective_end_date date;
99: l_object_version_number2 number;
100: l_business_group_id number:= p_business_group_id;
101: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
102: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
103: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
104:
105: begin

Line 102: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;

98: l_effective_end_date date;
99: l_object_version_number2 number;
100: l_business_group_id number:= p_business_group_id;
101: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
102: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
103: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
104:
105: begin
106: savepoint create_eligibility_object_s;

Line 103: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

99: l_object_version_number2 number;
100: l_business_group_id number:= p_business_group_id;
101: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
102: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
103: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
104:
105: begin
106: savepoint create_eligibility_object_s;
107:

Line 204: ben_elig_obj_elig_profl_f eop

200: EO.elig_obj_id ,
201: EO.object_version_number
202: from
203: ben_elig_obj_f EO,
204: ben_elig_obj_elig_profl_f eop
205: where
206: p_effective_date between eo.EFFECTIVE_START_DATE and eo.EFFECTIVE_END_DATE
207: and TABLE_NAME = p_TABLE_NAME
208: and COLUMN_NAME = p_COLUMN_NAME

Line 219: ben_elig_obj_elig_profl_f

215: cursor check_elig_obj_asso_id_exist(p_elig_obj_id in number) is
216: select
217: elig_obj_elig_prfl_id
218: from
219: ben_elig_obj_elig_profl_f
220: where
221: p_effective_date between effective_start_date and effective_end_date
222: and elig_obj_id = p_elig_obj_id
223: and rownum < 2;

Line 227: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

223: and rownum < 2;
224:
225: l_elig_object_id ben_elig_obj_f.elig_obj_id%type;
226: l_obj_version ben_elig_obj_f.object_version_number%type;
227: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
228: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
229: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
230: l_effective_start_date date;
231: l_effective_end_date date;

Line 228: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;

224:
225: l_elig_object_id ben_elig_obj_f.elig_obj_id%type;
226: l_obj_version ben_elig_obj_f.object_version_number%type;
227: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
228: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
229: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
230: l_effective_start_date date;
231: l_effective_end_date date;
232: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

Line 229: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;

225: l_elig_object_id ben_elig_obj_f.elig_obj_id%type;
226: l_obj_version ben_elig_obj_f.object_version_number%type;
227: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
228: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
229: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
230: l_effective_start_date date;
231: l_effective_end_date date;
232: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
233: begin

Line 232: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

228: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
229: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
230: l_effective_start_date date;
231: l_effective_end_date date;
232: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
233: begin
234:
235: savepoint delete_eligibility_object;
236:

Line 307: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

303: ,p_effective_date in date
304: ,p_datetrack_mode in varchar2
305: ) is
306:
307: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
308: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
309: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
310:
311: cursor c_obj_det is

Line 308: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;

304: ,p_datetrack_mode in varchar2
305: ) is
306:
307: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
308: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
309: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
310:
311: cursor c_obj_det is
312: select TABLE_NAME,

Line 309: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;

305: ) is
306:
307: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
308: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
309: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
310:
311: cursor c_obj_det is
312: select TABLE_NAME,
313: COLUMN_NAME,

Line 386: from ben_elig_obj_elig_profl_f

382: select elig_prfl_id,
383: nvl(mndtry_flag,'N'),
384: 'Y',
385: 'N'
386: from ben_elig_obj_elig_profl_f
387: where elig_obj_id = p_elig_obj_id
388: and p_effective_date between effective_start_date
389: and effective_end_date
390: order by decode(mndtry_flag,'Y',1,2);