APPS.PAY_NO_ABSENCE dependencies on FND_LOOKUP_VALUES

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

495: /* pgopal - passing the abs category code directly by attaching a value set to the element i/p value*/
496: /* BEGIN
497: SELECT LOOKUP_CODE
498: INTO l_abs_category_code
499: FROM HR_LOOKUPS /* Bug fix 5263714 used hr_lookups instead of fnd_lookup_values
500: FROM FND_LOOKUP_VALUES
501: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
502: AND ENABLED_FLAG = 'Y'
503: AND MEANING = p_absence_category;

Line 500: FROM FND_LOOKUP_VALUES

496: /* BEGIN
497: SELECT LOOKUP_CODE
498: INTO l_abs_category_code
499: FROM HR_LOOKUPS /* Bug fix 5263714 used hr_lookups instead of fnd_lookup_values
500: FROM FND_LOOKUP_VALUES
501: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
502: AND ENABLED_FLAG = 'Y'
503: AND MEANING = p_absence_category;
504: EXCEPTION

Line 801: FROM FND_LOOKUP_VALUES LKP

797: -- Fetch absence reason from the lookup
798: BEGIN
799: SELECT LKP.Meaning
800: INTO l_abs_reason
801: FROM FND_LOOKUP_VALUES LKP
802: ,PER_ABSENCE_ATTENDANCES PAA
803: ,PER_ABS_ATTENDANCE_REASONS PAR
804: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
805: AND PAA.ABS_ATTENDANCE_REASON_ID = PAR.ABS_ATTENDANCE_REASON_ID

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

6719: -- To select absence category code by passing absence category meaning.
6720: /* BEGIN
6721: SELECT LOOKUP_CODE
6722: INTO l_abs_category_code
6723: FROM HR_LOOKUPS /* Bug Fix 5263714 referred hr_lookups instead of fnd_lookup_values
6724: FROM FND_LOOKUP_VALUES
6725: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
6726: AND ENABLED_FLAG = 'Y'
6727: AND MEANING = p_abs_category;

Line 6724: FROM FND_LOOKUP_VALUES

6720: /* BEGIN
6721: SELECT LOOKUP_CODE
6722: INTO l_abs_category_code
6723: FROM HR_LOOKUPS /* Bug Fix 5263714 referred hr_lookups instead of fnd_lookup_values
6724: FROM FND_LOOKUP_VALUES
6725: WHERE LOOKUP_TYPE = 'ABSENCE_CATEGORY'
6726: AND ENABLED_FLAG = 'Y'
6727: AND MEANING = p_abs_category;
6728: EXCEPTION