DBA Data[Home] [Help]

APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on PAY_ASSIGNMENT_ACTIONS

Line 360: FROM pay_assignment_actions paa,

356: paa1.payroll_action_id, -- archiver payroll_action_id
357: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),
358: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
359: pai.effective_date
360: FROM pay_assignment_actions paa,
361: pay_payroll_actions ppa,
362: pay_assignment_actions paa1,
363: pay_payroll_actions ppa1,
364: pay_action_information pai

Line 362: pay_assignment_actions paa1,

358: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
359: pai.effective_date
360: FROM pay_assignment_actions paa,
361: pay_payroll_actions ppa,
362: pay_assignment_actions paa1,
363: pay_payroll_actions ppa1,
364: pay_action_information pai
365: where ppa.payroll_action_id = paa.payroll_action_id
366: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')