DBA Data[Home] [Help]

APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on PAY_ASSIGNMENT_ACTIONS

Line 372: FROM pay_assignment_actions paa,

368: paa1.payroll_action_id, -- archiver payroll_action_id
369: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),
370: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
371: pai.effective_date
372: FROM pay_assignment_actions paa,
373: pay_payroll_actions ppa,
374: pay_assignment_actions paa1,
375: pay_payroll_actions ppa1,
376: pay_action_information pai

Line 374: pay_assignment_actions paa1,

370: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
371: pai.effective_date
372: FROM pay_assignment_actions paa,
373: pay_payroll_actions ppa,
374: pay_assignment_actions paa1,
375: pay_payroll_actions ppa1,
376: pay_action_information pai
377: where ppa.payroll_action_id = paa.payroll_action_id
378: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')