APPS.HR_LOC_ABSENCE dependencies on PAY_INPUT_VALUES_F

Line 58: ,pay_input_values_f piv

54: ,pay_element_types_f pet
55: ,pay_element_links_f pel
56: ,pay_element_entries_f pee
57: ,pay_element_entry_values_f peev
58: ,pay_input_values_f piv
59: where abs.absence_attendance_id = p_absence_attendance_id
60: and abs.person_id = asg.person_id
61: and asg.assignment_id = p_assignment_id
62: and nvl(abs.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 121: FROM pay_input_values_f iv

117: --
118: CURSOR csr_entry_values(p_element_type_id NUMBER, p_iv1_name VARCHAR2, p_iv1_value VARCHAR2, p_effective_date DATE) IS
119: SELECT iv.input_value_id input_value
120: ,p_iv1_value entry_value
121: FROM pay_input_values_f iv
122: WHERE iv.element_type_id = p_element_type_id
123: AND iv.name = p_iv1_name
124: AND p_effective_date BETWEEN iv.effective_start_date AND iv.effective_end_date;
125:

Line 913: ,pay_input_values_f piv

909: ,pay_element_types_f pet
910: ,pay_element_links_f pel
911: ,pay_element_entries_f pee
912: ,pay_element_entry_values_f peev
913: ,pay_input_values_f piv
914: where abs.absence_attendance_id = p_absence_attendance_id
915: and abs.person_id = asg.person_id
916: and asg.assignment_id = p_assignment_id
917: and nvl(abs.date_start,asg.effective_end_date) <= asg.effective_end_date

Line 1329: FROM pay_input_values_f iv

1325: --
1326: CURSOR csr_entry_values(p_element_type_id NUMBER, p_iv1_name VARCHAR2, p_iv1_value VARCHAR2, p_effective_date DATE) IS
1327: SELECT iv.input_value_id input_value1
1328: ,p_iv1_value entry_value1
1329: FROM pay_input_values_f iv
1330: WHERE iv.element_type_id = p_element_type_id
1331: AND iv.name = p_iv1_name
1332: AND p_effective_date BETWEEN iv.effective_start_date AND iv.effective_end_date;
1333:

Line 1725: ,pay_input_values_f piv

1721: ,pay_element_types_f pet
1722: ,pay_element_links_f pel
1723: ,pay_element_entries_f pee
1724: ,pay_element_entry_values_f peev
1725: ,pay_input_values_f piv
1726: where abs.absence_attendance_id = p_absence_attendance_id
1727: and abs.person_id = asg.person_id
1728: and asg.assignment_id = p_assignment_id
1729: and nvl(abs.date_start,asg.effective_end_date) <= asg.effective_end_date