APPS.PQP_GB_PSI_WPS_HISTORY dependencies on PAY_INPUT_VALUES_F

Line 66: ,pay_input_values_f piv

62: )
63: IS
64: SELECT peev.screen_entry_value
65: FROM pay_element_entry_values_f peev
66: ,pay_input_values_f piv
67: WHERE peev.element_entry_id = p_element_entry_id
68: AND piv.input_value_id = peev.input_value_id
69: AND piv.NAME = p_input_value_name
70: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date;

Line 83: ,pay_input_values_f piv

79: IS
80: SELECT peev.screen_entry_value,peev.element_entry_id
81: FROM pay_element_entries_f pee
82: ,pay_element_entry_values_f peev
83: ,pay_input_values_f piv
84: WHERE pee.assignment_id=p_assignment_id
85: AND pee.element_type_id = p_element_type_id
86: AND peev.element_entry_id = pee.element_entry_id
87: AND piv.input_value_id = peev.input_value_id

Line 177: ,pay_input_values_f piv

173: IS
174: SELECT peev.screen_entry_value
175: FROM pay_element_entries_f pee
176: ,pay_element_entry_values_f peev
177: ,pay_input_values_f piv
178: WHERE pee.assignment_id=p_assignment_id
179: AND pee.element_type_id = p_element_type_id
180: AND peev.element_entry_id = pee.element_entry_id
181: AND piv.input_value_id = peev.input_value_id

Line 199: ,pay_input_values_f piv

195: FROM pay_element_types_f pet
196: ,pay_element_entries_f pee
197: ,pay_element_type_extra_info pete
198: ,pay_element_entry_values_f peev
199: ,pay_input_values_f piv
200: WHERE pee.assignment_id = p_assignment_id -- 301168
201: AND pee.element_type_id = pet.element_type_id -- 172156
202: AND pet.element_name like '%Buy Back FWC'
203: AND pet.element_type_id = pete.element_type_id