DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 155: ,pay_element_entry_values_f peev

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

Line 207: FROM pay_element_entry_values_f peev1

203: AND pel1.effective_start_date BETWEEN pet1.effective_start_date
204: AND pet1.effective_end_date
205: )
206: AND peev.effective_start_date = (SELECT max(peev1.effective_start_date)
207: FROM pay_element_entry_values_f peev1
208: WHERE peev1.element_entry_value_id = peev.element_entry_value_id
209: AND peev1.effective_start_date <= c_report_end_date)
210: /* 8352719 - removed the redundant join */
211: AND c_report_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date /* 4620635 */