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_ATTENDANCES

Line 4168: ,per_absence_attendances abs

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
4172: and abt.absence_category = 'S'

Line 4183: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;

4179: and v_eff_date between peev.effective_start_date and peev.effective_end_date
4180: and v_eff_date between pee.effective_start_date and pee.effective_end_date;
4181:
4182: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4183: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4184: ld_start_date per_absence_attendances.date_start%TYPE;
4185: ld_end_date per_absence_attendances.date_end%TYPE;
4186:
4187: -- The "sick_pay" looks for hours entered against Sick absence types in

Line 4184: ld_start_date per_absence_attendances.date_start%TYPE;

4180: and v_eff_date between pee.effective_start_date and pee.effective_end_date;
4181:
4182: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4183: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4184: ld_start_date per_absence_attendances.date_start%TYPE;
4185: ld_end_date per_absence_attendances.date_end%TYPE;
4186:
4187: -- The "sick_pay" looks for hours entered against Sick absence types in
4188: -- the current period. The number of hours are summed and multiplied by the

Line 4185: ld_end_date per_absence_attendances.date_end%TYPE;

4181:
4182: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4183: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4184: ld_start_date per_absence_attendances.date_start%TYPE;
4185: ld_end_date per_absence_attendances.date_end%TYPE;
4186:
4187: -- The "sick_pay" looks for hours entered against Sick absence types in
4188: -- the current period. The number of hours are summed and multiplied by the
4189: -- current rate of Regular Pay.

Line 4301: ,per_absence_attendances abs

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
4305: and abt.absence_category = 'V'

Line 4316: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;

4312: and v_eff_date between peev.effective_start_date and peev.effective_end_date
4313: and v_eff_date between pee.effective_start_date and pee.effective_end_date;
4314:
4315: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4316: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4317: ld_start_date per_absence_attendances.date_start%TYPE;
4318: ld_end_date per_absence_attendances.date_end%TYPE;
4319:
4320: -- The "vacation_pay" fn looks for hours entered against absence types

Line 4317: ld_start_date per_absence_attendances.date_start%TYPE;

4313: and v_eff_date between pee.effective_start_date and pee.effective_end_date;
4314:
4315: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4316: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4317: ld_start_date per_absence_attendances.date_start%TYPE;
4318: ld_end_date per_absence_attendances.date_end%TYPE;
4319:
4320: -- The "vacation_pay" fn looks for hours entered against absence types
4321: -- in the current period. The number of hours are summed and multiplied by

Line 4318: ld_end_date per_absence_attendances.date_end%TYPE;

4314:
4315: ln_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
4316: ln_abs_att_id per_absence_attendances.absence_attendance_id%TYPE;
4317: ld_start_date per_absence_attendances.date_start%TYPE;
4318: ld_end_date per_absence_attendances.date_end%TYPE;
4319:
4320: -- The "vacation_pay" fn looks for hours entered against absence types
4321: -- in the current period. The number of hours are summed and multiplied by
4322: -- the current rate of Regular Pay..