APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_PEOPLE_EXTRA_INFO

Line 271: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO

267: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
268: order by paa.person_id, ac3.context;
269:
270:
271: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
272: cursor a8b_esop_details is
273: select distinct 'ASSIGNMENT_ACTION_ID=C',
274: aac.assignment_action_id,
275: 'TAX_UNIT_ID=C',

Line 284: per_people_extra_info ppei, --per_assignment_extra_info paei, /* Bug 2691877 */

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,
288: pay_assignment_actions aac,

Line 315: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO

311: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
312: and paa.assignment_id = mac.assignment_id /* Bug 2676415 */
313: order by paa.person_id, ac3.context;
314:
315: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
316: cursor a8b_eesop_details is
317: select distinct 'ASSIGNMENT_ACTION_ID=C',
318: aac.assignment_action_id,
319: 'TAX_UNIT_ID=C',

Line 328: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */

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,
332: pay_assignment_actions aac,

Line 359: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO

355: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
356: and paa.assignment_id = mac.assignment_id
357: order by paa.person_id, ac3.context;
358:
359: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
360: cursor a8b_csop_details is
361: select distinct 'ASSIGNMENT_ACTION_ID=C',
362: aac.assignment_action_id,
363: 'TAX_UNIT_ID=C',

Line 372: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */

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,
376: pay_assignment_actions aac,

Line 403: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO

399: and paa.effective_end_date >= to_date('01/' || '01/' || pay_core_utils.get_parameter('BASIS_YEAR', apa.legislative_parameters),'dd/mm/yyyy'))
400: and paa.assignment_id = mac.assignment_id
401: order by paa.person_id, ac3.context;
402:
403: -- Bug 3501956. Modified to retrieve information from PER_PEOPLE_EXTRA_INFO
404: cursor a8b_total_details is
405: select distinct 'ASSIGNMENT_ACTION_ID=C',
406: aac.assignment_action_id,
407: 'TAX_UNIT_ID=C',

Line 412: per_people_extra_info ppei, -- per_assignment_extra_info paei, /* Bug 2691877 */

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,
416: pay_assignment_actions aac,