DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_API dependencies on PAY_INPUT_VALUES_F

Line 2016: ,pay_input_values_f piv

2012: ,pee.effective_end_date
2013: from per_absence_attendances abs
2014: ,per_all_assignments_f asg
2015: ,per_absence_attendance_types abt
2016: ,pay_input_values_f piv
2017: ,pay_element_types_f pet
2018: ,pay_element_links_f pel
2019: ,pay_element_entries_f pee
2020: where abs.absence_attendance_id = p_absence_attendance_id

Line 2064: pay_input_values_f piv,

2060:
2061: cursor c_get_processing_type is
2062: select upper(pet.processing_type)
2063: from per_absence_attendance_types abt,
2064: pay_input_values_f piv,
2065: pay_element_types_f pet
2066: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2067: and abt.input_value_id = piv.input_value_id
2068: and piv.element_type_id = pet.element_type_id;

Line 2116: pay_input_values_f piv,

2112: pet.element_type_id,
2113: pet.processing_type
2114: from per_absence_attendances aba,
2115: per_absence_attendance_types abt,
2116: pay_input_values_f piv,
2117: pay_element_types_f pet
2118: where aba.absence_attendance_id = p_absence_attendance_id
2119: and aba.absence_attendance_type_id = abt.absence_attendance_type_id
2120: and abt.input_value_id = piv.input_value_id