APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_PEOPLE_F

Line 73: ' FROM per_people_f p,' ||

69:
70: /*Bug2920725 Corrected base tables to support security model*/
71:
72: p_sql := ' SELECT distinct p.person_id' ||
73: ' FROM per_people_f p,' ||
74: ' pay_payroll_actions pa ' ||
75: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
76: ' AND p.business_group_id = pa.business_group_id' ||
77: ' ORDER BY p.person_id';

Line 147: ,per_people_f pap

143: decode(sign(nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) - c_report_end_date),1,
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

Line 177: FROM per_people_f p

173: and a.effective_start_date <= c_report_end_Date /*5474358 */
174: group by a.assignment_id
175: )
176: AND pap.effective_start_date = (SELECT max(effective_Start_date)
177: FROM per_people_f p
178: WHERE p.person_id = pap.person_id
179: and p.effective_start_Date <= c_report_end_date /*5474358 */
180: group by p.person_id)
181: AND pet.element_name = 'Tax Information'