APPS.HR_ABSUTIL_SS dependencies on FND_LOOKUP_VALUES

Line 206: Cursor c_lookup_code(AbsenceCat varchar2) is select LOOKUP_CODE from fnd_lookup_values flv

202: c_proc constant varchar2(30) := 'getAbsenceCategoryCode';
203: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;
204: l_lookup_code_val varchar2(10);
205:
206: Cursor c_lookup_code(AbsenceCat varchar2) is select LOOKUP_CODE from fnd_lookup_values flv
207: where flv.MEANING = AbsenceCat and flv.lookup_type = 'ABSENCE_CATEGORY';
208: begin
209: g_debug := hr_utility.debug_enabled;
210: if g_debug then

Line 323: lv_approvalStatus fnd_lookup_values.meaning%type;

319: p_absence_attendance_id in number) return varchar2
320:
321: IS
322: c_proc constant varchar2(30) := 'getApprovalStatus';
323: lv_approvalStatus fnd_lookup_values.meaning%type;
324: begin
325: g_debug := hr_utility.debug_enabled;
326: if g_debug then
327: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 422: from fnd_lookup_values

418: end if;
419: if(p_transaction_id is not null) then
420: begin
421: select (SELECT meaning
422: from fnd_lookup_values
423: where lookup_type ='ABSENCE_STATUS'
424: and fnd_lookup_values.lookup_code=Information9
425: and language = userenv('LANG')
426: )

Line 424: and fnd_lookup_values.lookup_code=Information9

420: begin
421: select (SELECT meaning
422: from fnd_lookup_values
423: where lookup_type ='ABSENCE_STATUS'
424: and fnd_lookup_values.lookup_code=Information9
425: and language = userenv('LANG')
426: )
427: into lv_AbsenceStatus
428: from hr_api_transaction_steps

Line 801: from fnd_lookup_values

797: end if;
798: if(p_transaction_id is not null) then
799: begin
800: select (SELECT meaning
801: from fnd_lookup_values
802: where lookup_type ='ABSENCE_STATUS'
803: and fnd_lookup_values.lookup_code=Information9
804: and language = userenv('LANG')
805: )

Line 803: and fnd_lookup_values.lookup_code=Information9

799: begin
800: select (SELECT meaning
801: from fnd_lookup_values
802: where lookup_type ='ABSENCE_STATUS'
803: and fnd_lookup_values.lookup_code=Information9
804: and language = userenv('LANG')
805: )
806: into lv_AbsenceStatus
807: from hr_api_transaction_steps