APPS.PQP_GB_OSP_FUNCTIONS dependencies on HR_LOOKUPS

Line 78: ,hr_lookups lkp

74: IS
75: SELECT lkp.meaning
76: FROM per_absence_attendances ABS
77: ,per_absence_attendance_types TYPE
78: ,hr_lookups lkp
79: WHERE ABS.absence_attendance_type_id = TYPE.absence_attendance_type_id
80: AND TYPE.absence_category = lkp.lookup_code
81: AND lkp.lookup_type = 'ABSENCE_CATEGORY'
82: AND ABS.absence_attendance_id = p_absence_attendance_id;

Line 90: ,hr_lookups lkp

86: IS
87: SELECT lkp.meaning
88: FROM per_absence_attendances ABS
89: ,per_abs_attendance_reasons rea
90: ,hr_lookups lkp
91: WHERE ABS.abs_attendance_reason_id = rea.abs_attendance_reason_id
92: AND rea.NAME = lkp.lookup_code
93: AND lookup_type = 'ABSENCE_REASON'
94: AND ABS.absence_attendance_id = p_absence_attendance_id;

Line 144: ,hr_lookups lookup

140: ,inst.VALUE
141: FROM pay_user_columns cols
142: ,pay_user_rows_f pur
143: ,pay_user_column_instances_f inst
144: ,hr_lookups lookup
145: WHERE cols.user_table_id = p_table_id
146: AND pur.user_table_id = cols.user_table_id
147: AND pur.user_row_id = inst.user_row_id
148: AND cols.user_column_id = inst.user_column_id

Line 423: FROM hr_lookups

419: CURSOR csr_get_lookup_info(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2)
420: IS
421: SELECT meaning
422: ,lookup_code
423: FROM hr_lookups
424: WHERE lookup_type = c_lookup_type
425: AND lookup_code LIKE c_lookup_code
426: AND enabled_flag = 'Y'
427: ORDER BY lookup_code;