APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_PEOPLE_F

Line 142: ,per_people_f pap

138: FROM hr_organization_information hoi
139: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all
140: ,fnd_territories_tl ftl
141: ,hr_organization_units hou
142: ,per_people_f pap
143: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
144: AND hou.organization_id = hoi.organization_id
145: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
146: AND hoi.org_information_context = 'AU_LEGAL_EMPLOYER'

Line 152: FROM per_people_f p

148: AND ftl.language(+) = userenv('LANG')
149: AND hlc.location_id(+) = hou.location_id
150: AND hoi.org_information7 = pap.person_id
151: AND pap.effective_start_date = (SELECT max(effective_start_date)
152: FROM per_people_f p
153: WHERE pap.person_id=p.person_id
154: and p.effective_start_date <= /* 5474358 */
155: fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'))
156: group by p.person_id);

Line 201: ,per_people_f pap

197: FROM hr_organization_information hoi
198: ,hr_locations_all hlc --Modified the table from hr_locations to hr_locations_all
199: ,fnd_territories_tl ftl
200: ,hr_organization_units hou
201: ,per_people_f pap
202: WHERE hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
203: AND hou.organization_id = hoi.organization_id
204: AND hoi.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_EMPLOYER')
205: AND hoi.org_information_context = 'AU_LEGAL_EMPLOYER'

Line 211: FROM per_people_f p

207: AND ftl.language(+) = userenv('LANG')
208: AND hlc.location_id(+) = hou.location_id
209: AND hoi.org_information7 = pap.person_id
210: AND pap.effective_start_date = (SELECT max(effective_start_date)
211: FROM per_people_f p
212: WHERE pap.person_id=p.person_id
213: and p.effective_start_date <= /* 5474358 */
214: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY')
215: group by p.person_id );

Line 295: ,per_people_f pap

291: ,nvl(pay_au_tfn_magtape_flags.get_tfn_flag_values(paa.assignment_id,'SENIOR_FLAG'),'N')
292: FROM
293: hr_soft_coding_keyflex hsc
294: ,per_assignments_f paa
295: ,per_people_f pap
296: ,per_addresses pad
297: ,pay_payroll_actions ppa
298: ,pay_assignment_actions pac
299: WHERE paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id

Line 316: FROM per_people_f p

312: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /*5474358 */
313: group by a.assignment_id /*Bug4247686 */
314: )
315: AND pap.effective_start_date = ( SELECT max(effective_Start_date)
316: FROM per_people_f p
317: WHERE p.person_id = pap.person_id
318: and p.effective_start_date < =
319: to_date(pay_magtape_generic.get_parameter_value('REPORT_END_DATE'),'DD-MM-YYYY') /*5474358 */
320: group by p.person_id /*Bug4247686 */