APPS.PAY_CA_T4A_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 235: from pay_assignment_actions paa

231: hr_utility.trace('In get_final_xml 20');
232:
233: select paa.payroll_action_id
234: into l_pa_id
235: from pay_assignment_actions paa
236: where paa.assignment_action_id = p_assignment_action_id;
237:
238: lv_negative_bal_flag := 'N';
239: lv_negative_bal_flag := pay_ca_archive_utils.get_archive_value(p_assignment_action_id ,

Line 350: from pay_assignment_actions paa,

346: cursor c_get_params is
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

Line 352: pay_assignment_actions paa1,

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')
356: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

Line 585: pay_assignment_actions paa

581: for 'Employer Address' is 'N' */
582: cursor cur_gre_name is
583: select name
584: from hr_all_organization_units hou,
585: pay_assignment_actions paa
586: where paa.assignment_action_id = l_aa_id
587: and paa.tax_unit_id = hou.organization_id;
588:
589: begin

Line 1243: from pay_assignment_actions paa,

1239:
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

Line 1245: pay_assignment_actions paa1,

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')
1249: and substr(paa.serial_number,29,1) = 'Y'