DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PAY_MAGTAPE_GENERIC

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

172: pay_payroll_actions ppa,
173: pay_assignment_actions paa1,
174: pay_payroll_actions ppa1
175: where ppa.payroll_action_id = paa.payroll_action_id
176: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
177: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
178: and to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id
179: and paa1.payroll_action_id = ppa1.payroll_action_id
180: and ppa1.report_type = 'T4'

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

173: pay_assignment_actions paa1,
174: pay_payroll_actions ppa1
175: where ppa.payroll_action_id = paa.payroll_action_id
176: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
177: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
178: and to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id
179: and paa1.payroll_action_id = ppa1.payroll_action_id
180: and ppa1.report_type = 'T4'
181: and ppa1.action_type = 'X'