DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 153: ,pay_element_entry_values_f peev

149: ,pay_element_entries_f pee
150: ,pay_element_links_f pel
151: ,pay_element_types_f pet
152: ,pay_input_values_f piv
153: ,pay_element_entry_values_f peev
154: WHERE ppa.payroll_action_id = c_payroll_action_id
155: AND pap.person_id BETWEEN c_start_person_id AND c_end_person_id
156: AND pap.person_id = paa.person_id
157: AND paa.business_group_id = c_business_group_id

Line 205: FROM pay_element_entry_values_f peev1

201: AND pel1.effective_start_date BETWEEN pet1.effective_start_date
202: AND pet1.effective_end_date
203: )
204: AND peev.effective_start_date = (SELECT max(peev1.effective_start_date)
205: FROM pay_element_entry_values_f peev1
206: WHERE peev1.element_entry_value_id = peev.element_entry_value_id
207: AND peev1.effective_start_date <= c_report_end_date)
208: /* 4620635 */
209: AND ((