eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4A_XML dependencies on PAY_PAYROLL_ACTIONS

Line 351: pay_payroll_actions ppa,

347: select paa1.assignment_action_id, -- archiver asg action
348: ppa1.payroll_action_id, -- archiver pact
349: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters) -- Added for Bug 12943928
350: from pay_assignment_actions paa,
351: pay_payroll_actions ppa,
352: pay_assignment_actions paa1,
353: pay_payroll_actions ppa1
354: where ppa.payroll_action_id = paa.payroll_action_id
355: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 353: pay_payroll_actions ppa1

349: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters) -- Added for Bug 12943928
350: from pay_assignment_actions paa,
351: pay_payroll_actions ppa,
352: pay_assignment_actions paa1,
353: pay_payroll_actions ppa1
354: where ppa.payroll_action_id = paa.payroll_action_id
355: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
356: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
357: and fnd_number.canonical_to_number(substr(paa.serial_number,1,14)) = paa1.assignment_action_id

Line 1244: pay_payroll_actions ppa,

1240: cursor c_get_params is
1241: select paa1.assignment_action_id, -- archiver asg action
1242: ppa1.payroll_action_id -- archiver pact
1243: from pay_assignment_actions paa,
1244: pay_payroll_actions ppa,
1245: pay_assignment_actions paa1,
1246: pay_payroll_actions ppa1
1247: where ppa.payroll_action_id = paa.payroll_action_id
1248: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 1246: pay_payroll_actions ppa1

1242: ppa1.payroll_action_id -- archiver pact
1243: from pay_assignment_actions paa,
1244: pay_payroll_actions ppa,
1245: pay_assignment_actions paa1,
1246: pay_payroll_actions ppa1
1247: where ppa.payroll_action_id = paa.payroll_action_id
1248: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1249: and substr(paa.serial_number,29,1) = 'Y'
1250: --and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')