DBA Data[Home] [Help]

APPS.PAY_SEED_UTL dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 63: from per_absence_attendance_types

59:
60: -- Cursor to retrieve absence_type_id given name
61: CURSOR c_absence_type_id(p_absence_type_name VARCHAR2) IS
62: select ABSENCE_ATTENDANCE_TYPE_ID
63: from per_absence_attendance_types
64: where name = p_absence_type_name
65: and business_group_id IS NULL;
66:
67: -- Cursor to retrieve balance_type_id given name

Line 279: from per_absence_attendance_types

275:
276: -- Cursor to retrieve absence_type_id given name
277: CURSOR c_absence_type_id(p_absence_type_name VARCHAR2) IS
278: select ABSENCE_ATTENDANCE_TYPE_ID
279: from per_absence_attendance_types
280: where name = p_absence_type_name
281: and business_group_id IS NULL;
282:
283: -- Cursor to retrieve balance_type_id given name