APPS.PAY_US_W2_INFO_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 550: FROM pay_payroll_actions ppa

546:
547: CURSOR c_get_session_date IS
548: SELECT NVL(TO_DATE(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',
549: ppa.legislative_parameters),'YYYY/MM/DD'),SYSDATE) session_date
550: FROM pay_payroll_actions ppa
551: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
552:
553: c_get_session_date_rec c_get_session_date%ROWTYPE;
554:

Line 1813: pay_payroll_actions ppa,

1809: hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),
1810: hr_us_w2_mt.get_parameter('p_instr_template',ppa.legislative_parameters),
1811: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
1812: FROM pay_assignment_actions paa,
1813: pay_payroll_actions ppa,
1814: pay_assignment_actions paa1,
1815: pay_payroll_actions ppa1
1816: where ppa.payroll_action_id = paa.payroll_action_id
1817: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 1815: pay_payroll_actions ppa1

1811: hr_us_w2_mt.get_parameter('print_instrunction',ppa.legislative_parameters)
1812: FROM pay_assignment_actions paa,
1813: pay_payroll_actions ppa,
1814: pay_assignment_actions paa1,
1815: pay_payroll_actions ppa1
1816: where ppa.payroll_action_id = paa.payroll_action_id
1817: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1818: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
1819: and paa.serial_number = paa1.assignment_action_id