DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_ASSIGNMENTS_F

Line 148: ,per_assignments_f paa

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

Line 171: FROM per_assignments_f a

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