APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 276: ,pay_payroll_actions ppa35

272: ,pai_prsi.action_information26 asg_location_id -- 10277535
273: FROM pay_action_information pai /*Employee Details Info*/
274: ,pay_action_information pai_prsi /* prsi Details 5657992 */
275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa
278: ,per_assignments_f paf
279: ,per_periods_of_service pps
280: ,pay_ie_paye_details_f payef -- 10277535

Line 343: ,pay_payroll_actions ppax

339: prsif.effective_end_date IS NULL
340: )
341: -- Bug 3446744 Removed the check of a P45 existence
342: /* and not exists (select 1 from pay_assignment_actions paax
343: ,pay_payroll_actions ppax
344: WHERE
345: paax.assignment_id = paa.assignment_id
346: and ppax.payroll_action_id = paax.payroll_action_id
347: and ppax.report_type = 'P45'

Line 392: FROM pay_assignment_actions paa,pay_payroll_actions ppa

388: ,c_assignment_id per_all_assignments.assignment_id%type
389: ,c_person_id per_all_people_f.person_id%type) is
390: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
391: paa.assignment_action_id),16))
392: FROM pay_assignment_actions paa,pay_payroll_actions ppa
393: WHERE ((c_ppsn is null and paa.assignment_id=c_assignment_id)
394: OR(c_ppsn is not null and paa.assignment_id in (select paaf.assignment_id
395: from per_all_assignments_f paaf, per_assignment_extra_info paei
396: where paaf.person_id = c_person_id

Line 413: ,pay_payroll_actions ppa

409: ) is
410: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
411: paa.assignment_action_id),16))
412: FROM pay_assignment_actions paa
413: ,pay_payroll_actions ppa
414: WHERE paa.assignment_id=c_assignment_id
415: AND paa.payroll_action_id=ppa.payroll_action_id
416: AND ppa.action_type in ('Q','B','R','I','V')
417: AND ppa.action_status ='C'

Line 426: ,pay_payroll_actions ppa

422: ) is
423: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
424: paa.assignment_action_id),16))
425: FROM pay_assignment_actions paa
426: ,pay_payroll_actions ppa
427: WHERE paa.assignment_id=c_assignment_id
428: AND paa.payroll_action_id=ppa.payroll_action_id
429: AND ppa.action_type in ('Q','B','R','I','V')
430: AND ppa.action_status ='C'

Line 510: pay_payroll_actions ppa

506: CURSOR c_get_max_aact(p_pds_id NUMBER, c_person_id NUMBER) IS
507: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
508: paa.assignment_action_id),16))
509: FROM pay_assignment_Actions paa,
510: pay_payroll_actions ppa
511:
512: WHERE paa.assignment_id in (SELECT assignment_id
513: FROM per_assignments_f
514: WHERE period_of_service_id = p_pds_id

Line 528: pay_payroll_actions ppa

524: c_person_id NUMBER) IS
525: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
526: paa.assignment_action_id),16))
527: FROM pay_assignment_Actions paa,
528: pay_payroll_actions ppa
529:
530: WHERE paa.assignment_id in (SELECT paf.assignment_id
531: FROM per_assignments_f paf, per_assignment_extra_info paei
532: WHERE paf.period_of_service_id = p_pds_id