DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_ASSIGNMENTS_F

Line 146: ,per_assignments_f paa

142: null,pps.actual_termination_date) actual_termination_date,
143: peev.screen_entry_value tax_file_number
144: FROM pay_payroll_actions ppa
145: ,per_people_f pap
146: ,per_assignments_f paa
147: ,hr_soft_coding_keyflex hsc
148: ,per_periods_of_service pps
149: ,pay_element_entries_f pee
150: ,pay_element_links_f pel

Line 168: FROM per_assignments_f a

164: where pps1.person_id=pps.person_id
165: AND pps1.date_start <= c_report_end_date
166: ) /*Bug2751008*/
167: AND paa.effective_start_date = (SELECT max(effective_Start_date)
168: FROM per_assignments_f a
169: WHERE a.assignment_id = paa.assignment_id
170: and a.effective_start_date <= c_report_end_Date /*5474358 */
171: group by a.assignment_id
172: )