DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1235: from per_absence_attendance_types abt,

1231:
1232: CURSOR get_vac_hours ( v_asg_id NUMBER,
1233: v_eff_date DATE) IS
1234: select fnd_number.canonical_to_number(pev.screen_entry_value)
1235: from per_absence_attendance_types abt,
1236: pay_element_entries_f pee,
1237: pay_element_entry_values_f pev
1238: where pev.input_value_id = abt.input_value_id
1239: and abt.absence_category = 'V'

Line 1301: from per_absence_attendance_types abt,

1297:
1298: CURSOR get_sick_hours ( v_asg_id NUMBER,
1299: v_eff_date DATE) IS
1300: select fnd_number.canonical_to_number(pev.screen_entry_value)
1301: from per_absence_attendance_types abt,
1302: pay_element_entries_f pee,
1303: pay_element_entry_values_f pev
1304: where pev.input_value_id = abt.input_value_id
1305: and abt.absence_category = 'S'