APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_ALL_ASSIGNMENTS_F

Line 165: from per_all_assignments_f paa,

161: 'ASSIGNMENT_NUMBER=P',
162: paa.assignment_number assignment_number
163: -- 'RECORD_INDICATOR_FLAG=P',
164: -- pay_sg_iras_magtape.return_indicator_flag(paa.assignment_id ,mpa.report_type)
165: from per_all_assignments_f paa,
166: pay_payroll_actions mpa,
167: pay_assignment_actions mac,
168: pay_payroll_actions apa,
169: pay_assignment_actions aac

Line 202: from per_all_assignments_f paa,

198: 'PERSON_ID=P',
199: to_char(paa.person_id) person_id,
200: 'DATE_ORDER=P',
201: fnd_date.canonical_to_date(ac3.context) date_order
202: from per_all_assignments_f paa,
203: pay_payroll_actions apa,
204: pay_assignment_actions aac,
205: pay_payroll_actions mpa,
206: ff_archive_items fai,

Line 246: per_all_assignments_f paa,

242: paa.person_id
243: from pay_payroll_actions mpa,
244: pay_payroll_actions apa,
245: pay_assignment_actions aac,
246: per_all_assignments_f paa,
247: ff_archive_items fai,
248: ff_archive_items fai1,
249: ff_database_items fdi,
250: ff_archive_item_contexts ac2,

Line 285: from per_all_assignments_f paa,

281: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P',
282: ac3.context person_extra_id, -- ac3.context ass_extra_id,
283: 'PERSON_ID=P',
284: to_char(paa.person_id) person_id
285: from per_all_assignments_f paa,
286: pay_payroll_actions mpa,
287: pay_assignment_actions mac,
288: pay_payroll_actions apa,
289: pay_assignment_actions aac,

Line 325: from per_all_assignments_f paa,

321: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P',
322: ac3.context person_extra_id, -- ac3.context ass_extra_id,
323: 'PERSON_ID=P',
324: to_char(paa.person_id) person_id
325: from per_all_assignments_f paa,
326: pay_payroll_actions mpa,
327: pay_assignment_actions mac,
328: pay_payroll_actions apa,
329: pay_assignment_actions aac,

Line 365: from per_all_assignments_f paa,

361: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P'
362: ac3.context person_extra_id, -- ac3.context ass_extra_id
363: 'PERSON_ID=P',
364: to_char(paa.person_id) person_id
365: from per_all_assignments_f paa,
366: pay_payroll_actions mpa,
367: pay_assignment_actions mac,
368: pay_payroll_actions apa,
369: pay_assignment_actions aac,

Line 405: from per_all_assignments_f paa,

401: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P'
402: ac3.context person_extra_id, -- ac3.context ass_extra_id
403: 'PERSON_ID=P',
404: to_char(paa.person_id) person_id
405: from per_all_assignments_f paa,
406: pay_payroll_actions mpa,
407: pay_assignment_actions mac,
408: pay_payroll_actions apa,
409: pay_assignment_actions aac,

Line 443: from per_all_assignments_f paa,

439: 'TAX_UNIT_ID=C',
440: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
441: 'PERSON_ID=P',
442: to_char(paa.person_id) person_id
443: from per_all_assignments_f paa,
444: pay_payroll_actions mpa,
445: pay_assignment_actions mac,
446: pay_payroll_actions apa,
447: pay_assignment_actions aac,