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 145: ,per_people_f pap

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

Line 174: FROM per_people_f p

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