APPS.HR_PERSON_ABSENCE_API dependencies on PAY_INPUT_VALUES_F

Line 2604: ,pay_input_values_f piv

2600: ,pee.effective_end_date
2601: from per_absence_attendances abs
2602: ,per_all_assignments_f asg
2603: ,per_absence_attendance_types abt
2604: ,pay_input_values_f piv
2605: ,pay_element_types_f pet
2606: ,pay_element_links_f pel
2607: ,pay_element_entries_f pee
2608: where abs.absence_attendance_id = p_absence_attendance_id

Line 2652: pay_input_values_f piv,

2648:
2649: cursor c_get_processing_type is
2650: select upper(pet.processing_type)
2651: from per_absence_attendance_types abt,
2652: pay_input_values_f piv,
2653: pay_element_types_f pet
2654: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2655: and abt.input_value_id = piv.input_value_id
2656: and piv.element_type_id = pet.element_type_id;

Line 2704: pay_input_values_f piv,

2700: pet.element_type_id,
2701: pet.processing_type
2702: from per_absence_attendances aba,
2703: per_absence_attendance_types abt,
2704: pay_input_values_f piv,
2705: pay_element_types_f pet
2706: where aba.absence_attendance_id = p_absence_attendance_id
2707: and aba.absence_attendance_type_id = abt.absence_attendance_type_id
2708: and abt.input_value_id = piv.input_value_id

Line 3203: pay_input_values_f piv,

3199: decode (hrtsteps.INFORMATION9,'CONFIRMED','Y','N') CONFIRMED_FLAG
3200: from hr_api_transactions hat,
3201: HR_API_TRANSACTION_STEPS hrtsteps,
3202: per_absence_attendance_types abt,
3203: pay_input_values_f piv,
3204: pay_element_types_f pet
3205: where
3206: hat.SELECTED_PERSON_ID = p_person_id
3207: --hat.creator_person_id = 125

Line 3240: pay_input_values_f piv,

3236: decode (aba.date_start,'','N','Y') CONFIRMED_FLAG
3237:
3238: from per_absence_attendances aba,
3239: per_absence_attendance_types abt,
3240: pay_input_values_f piv,
3241: pay_element_types_f pet
3242: where aba.person_id = p_person_id
3243: AND abt.absence_attendance_type_id= aba.absence_attendance_type_id
3244: and abt.input_value_id = piv.input_value_id (+)