APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_ALL_ASSIGNMENTS_F

Line 163: from per_all_assignments_f paa,

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

Line 200: from per_all_assignments_f paa,

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

Line 244: per_all_assignments_f paa,

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

Line 283: from per_all_assignments_f paa,

279: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P',
280: ac3.context person_extra_id, -- ac3.context ass_extra_id,
281: 'PERSON_ID=P',
282: to_char(paa.person_id) person_id
283: from per_all_assignments_f paa,
284: per_people_extra_info ppei, --per_assignment_extra_info paei, /* Bug 2691877 */
285: pay_payroll_actions mpa,
286: pay_assignment_actions mac,
287: pay_payroll_actions apa,

Line 327: from per_all_assignments_f paa,

323: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P',
324: ac3.context person_extra_id, -- ac3.context ass_extra_id,
325: 'PERSON_ID=P',
326: to_char(paa.person_id) person_id
327: from per_all_assignments_f paa,
328: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
329: pay_payroll_actions mpa,
330: pay_assignment_actions mac,
331: pay_payroll_actions apa,

Line 371: from per_all_assignments_f paa,

367: 'PERSON_EXTRA_ID=P', -- 'ASS_EXTRA_ID=P'
368: ac3.context person_extra_id, -- ac3.context ass_extra_id
369: 'PERSON_ID=P',
370: to_char(paa.person_id) person_id
371: from per_all_assignments_f paa,
372: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
373: pay_payroll_actions mpa,
374: pay_assignment_actions mac,
375: pay_payroll_actions apa,

Line 411: from per_all_assignments_f paa,

407: 'TAX_UNIT_ID=C',
408: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', apa.legislative_parameters) tax_unit_id,
409: 'PERSON_ID=P',
410: to_char(paa.person_id) person_id
411: from per_all_assignments_f paa,
412: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */
413: pay_payroll_actions mpa,
414: pay_assignment_actions mac,
415: pay_payroll_actions apa,