APPS.PAY_AU_TFN_MAGTAPE dependencies on PER_PEOPLE_F

Line 138: ,per_people_f pap

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

Line 148: FROM per_people_f p

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

Line 197: ,per_people_f pap

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

Line 207: FROM per_people_f p

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

Line 291: ,per_people_f pap

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

Line 312: FROM per_people_f p

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