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_CORE_FF_UDFS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1614: from per_absence_attendance_types abt,

1610:
1611: CURSOR get_vac_hours ( v_asg_id NUMBER,
1612: v_eff_date DATE) IS
1613: select fnd_number.canonical_to_number(pev.screen_entry_value)
1614: from per_absence_attendance_types abt,
1615: pay_element_entries_f pee,
1616: pay_element_entry_values_f pev
1617: where pev.input_value_id = abt.input_value_id
1618: and abt.absence_category = 'V'

Line 1680: from per_absence_attendance_types abt,

1676:
1677: CURSOR get_sick_hours ( v_asg_id NUMBER,
1678: v_eff_date DATE) IS
1679: select fnd_number.canonical_to_number(pev.screen_entry_value)
1680: from per_absence_attendance_types abt,
1681: pay_element_entries_f pee,
1682: pay_element_entry_values_f pev
1683: where pev.input_value_id = abt.input_value_id
1684: and abt.absence_category = 'S'

Line 4146: from per_absence_attendance_types abt,

4142: /*
4143: CURSOR get_sick_hours ( v_asg_id NUMBER,
4144: v_eff_date DATE) IS
4145: select fnd_number.canonical_to_number(pev.screen_entry_value)
4146: from per_absence_attendance_types abt,
4147: pay_element_entries_f pee,
4148: pay_element_entry_values_f pev
4149: where pev.input_value_id = abt.input_value_id
4150: and abt.absence_category = 'S'

Line 4167: from per_absence_attendance_types abt

4163: ,abs.absence_attendance_id
4164: ,abs.date_start
4165: ,abs.date_end
4166: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4167: from per_absence_attendance_types abt
4168: ,per_absence_attendances abs
4169: ,pay_element_entries_f pee
4170: ,pay_element_entry_values_f peev
4171: where abt.input_value_id = peev.input_value_id

Line 4279: from per_absence_attendance_types abt,

4275: /*
4276: CURSOR get_vac_hours ( v_asg_id NUMBER,
4277: v_eff_date DATE) IS
4278: select fnd_number.canonical_to_number(pev.screen_entry_value)
4279: from per_absence_attendance_types abt,
4280: pay_element_entries_f pee,
4281: pay_element_entry_values_f pev
4282: where pev.input_value_id = abt.input_value_id
4283: and abt.absence_category = 'V'

Line 4300: from per_absence_attendance_types abt

4296: ,abs.absence_attendance_id
4297: ,abs.date_start
4298: ,abs.date_end
4299: ,fnd_number.canonical_to_number(peev.screen_entry_value)
4300: from per_absence_attendance_types abt
4301: ,per_absence_attendances abs
4302: ,pay_element_entries_f pee
4303: ,pay_element_entry_values_f peev
4304: where abt.input_value_id = peev.input_value_id