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.PAY_NO_ABSENCE dependencies on FND_LOOKUP_VALUES

Line 526: FROM HR_LOOKUPS /* Bug fix 5263714 used hr_lookups instead of fnd_lookup_values

522: /* pgopal - passing the abs category code directly by attaching a value set to the element i/p value*/
523: /* BEGIN
524: SELECT LOOKUP_CODE
525: INTO l_abs_category_code
526: FROM HR_LOOKUPS /* Bug fix 5263714 used hr_lookups instead of fnd_lookup_values
527: FROM FND_LOOKUP_VALUES
528: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
529: AND ENABLED_FLAG = 'Y'
530: AND MEANING = p_absence_category;

Line 527: FROM FND_LOOKUP_VALUES

523: /* BEGIN
524: SELECT LOOKUP_CODE
525: INTO l_abs_category_code
526: FROM HR_LOOKUPS /* Bug fix 5263714 used hr_lookups instead of fnd_lookup_values
527: FROM FND_LOOKUP_VALUES
528: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
529: AND ENABLED_FLAG = 'Y'
530: AND MEANING = p_absence_category;
531: EXCEPTION

Line 828: FROM FND_LOOKUP_VALUES LKP

824: -- Fetch absence reason from the lookup
825: BEGIN
826: SELECT LKP.Meaning
827: INTO l_abs_reason
828: FROM FND_LOOKUP_VALUES LKP
829: ,PER_ABSENCE_ATTENDANCES PAA
830: ,PER_ABS_ATTENDANCE_REASONS PAR
831: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
832: AND PAA.ABS_ATTENDANCE_REASON_ID = PAR.ABS_ATTENDANCE_REASON_ID

Line 6823: FROM HR_LOOKUPS /* Bug Fix 5263714 referred hr_lookups instead of fnd_lookup_values

6819: -- To select absence category code by passing absence category meaning.
6820: /* BEGIN
6821: SELECT LOOKUP_CODE
6822: INTO l_abs_category_code
6823: FROM HR_LOOKUPS /* Bug Fix 5263714 referred hr_lookups instead of fnd_lookup_values
6824: FROM FND_LOOKUP_VALUES
6825: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
6826: AND ENABLED_FLAG = 'Y'
6827: AND MEANING = p_abs_category;

Line 6824: FROM FND_LOOKUP_VALUES

6820: /* BEGIN
6821: SELECT LOOKUP_CODE
6822: INTO l_abs_category_code
6823: FROM HR_LOOKUPS /* Bug Fix 5263714 referred hr_lookups instead of fnd_lookup_values
6824: FROM FND_LOOKUP_VALUES
6825: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
6826: AND ENABLED_FLAG = 'Y'
6827: AND MEANING = p_abs_category;
6828: EXCEPTION