DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 1708: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

1704: pay_payroll_actions ppa,
1705: pay_assignment_actions paa1,
1706: pay_payroll_actions ppa1
1707: where ppa.payroll_action_id = paa.payroll_action_id
1708: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1709: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
1710: and paa.serial_number = paa1.assignment_action_id
1711: and paa1.payroll_action_id = ppa1.payroll_action_id
1712: and ppa1.report_type = 'YREND'

Line 1709: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

1705: pay_assignment_actions paa1,
1706: pay_payroll_actions ppa1
1707: where ppa.payroll_action_id = paa.payroll_action_id
1708: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1709: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
1710: and paa.serial_number = paa1.assignment_action_id
1711: and paa1.payroll_action_id = ppa1.payroll_action_id
1712: and ppa1.report_type = 'YREND'
1713: and ppa1.action_type = 'X'