DBA Data[Home] [Help]

APPS.HR_ABSUTIL_SS dependencies on FND_LOOKUP_VALUES

Line 274: lv_approvalStatus fnd_lookup_values.meaning%type;

270: p_absence_attendance_id in number) return varchar2
271:
272: IS
273: c_proc constant varchar2(30) := 'getApprovalStatus';
274: lv_approvalStatus fnd_lookup_values.meaning%type;
275: begin
276: g_debug := hr_utility.debug_enabled;
277: if g_debug then
278: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 373: from fnd_lookup_values

369: end if;
370: if(p_transaction_id is not null) then
371: begin
372: select (SELECT meaning
373: from fnd_lookup_values
374: where lookup_type ='ABSENCE_STATUS'
375: and fnd_lookup_values.lookup_code=Information9
376: and language = userenv('LANG')
377: )

Line 375: and fnd_lookup_values.lookup_code=Information9

371: begin
372: select (SELECT meaning
373: from fnd_lookup_values
374: where lookup_type ='ABSENCE_STATUS'
375: and fnd_lookup_values.lookup_code=Information9
376: and language = userenv('LANG')
377: )
378: into lv_AbsenceStatus
379: from hr_api_transaction_steps

Line 752: from fnd_lookup_values

748: end if;
749: if(p_transaction_id is not null) then
750: begin
751: select (SELECT meaning
752: from fnd_lookup_values
753: where lookup_type ='ABSENCE_STATUS'
754: and fnd_lookup_values.lookup_code=Information9
755: and language = userenv('LANG')
756: )

Line 754: and fnd_lookup_values.lookup_code=Information9

750: begin
751: select (SELECT meaning
752: from fnd_lookup_values
753: where lookup_type ='ABSENCE_STATUS'
754: and fnd_lookup_values.lookup_code=Information9
755: and language = userenv('LANG')
756: )
757: into lv_AbsenceStatus
758: from hr_api_transaction_steps