APPS.PAY_CA_T4_XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 262: l_serial_number pay_assignment_actions.serial_number%TYPE;

258: l_type varchar2(240);
259: l_instructions varchar2(240);
260: /*Added for Bug#10359114 */
261: l_report_type pay_payroll_actions.report_type%TYPE;
262: l_serial_number pay_assignment_actions.serial_number%TYPE;
263: /*End Bug#10359114 */
264: l_output_location varchar2(100);
265: EOL varchar2(10);
266:

Line 278: from pay_assignment_actions paa,

274: pay_ca_t4_reg.get_parameter('TYPE',ppa.legislative_parameters),
275: pay_ca_t4_reg.get_parameter('PRINT',ppa.legislative_parameters),
276: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
277: substr(paa.serial_number,1,2)
278: from pay_assignment_actions paa,
279: pay_payroll_actions ppa,
280: pay_assignment_actions paa1,
281: pay_payroll_actions ppa1
282: where ppa.payroll_action_id = paa.payroll_action_id

Line 280: pay_assignment_actions paa1,

276: pay_ca_t4_reg.get_parameter('INSTRUCTIONS',ppa.legislative_parameters),
277: substr(paa.serial_number,1,2)
278: from pay_assignment_actions paa,
279: pay_payroll_actions ppa,
280: pay_assignment_actions paa1,
281: pay_payroll_actions ppa1
282: where ppa.payroll_action_id = paa.payroll_action_id
283: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
284: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

Line 301: cursor c_get_arch_action_ids (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is

297: select ppa.report_type
298: from pay_payroll_actions ppa
299: where ppa.payroll_action_id = c_payroll_action_id;
300:
301: cursor c_get_arch_action_ids (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
302: select paa2.assignment_action_id,paa2.payroll_action_id
303: from pay_assignment_actions paa1,
304: pay_assignment_actions paa2
305: where paa1.assignment_action_id = c_assignment_action_id

Line 303: from pay_assignment_actions paa1,

299: where ppa.payroll_action_id = c_payroll_action_id;
300:
301: cursor c_get_arch_action_ids (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
302: select paa2.assignment_action_id,paa2.payroll_action_id
303: from pay_assignment_actions paa1,
304: pay_assignment_actions paa2
305: where paa1.assignment_action_id = c_assignment_action_id
306: and substr(paa1.serial_number,3,14) = paa2.assignment_action_id
307: and paa1.assignment_id = paa2.assignment_id;

Line 304: pay_assignment_actions paa2

300:
301: cursor c_get_arch_action_ids (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is
302: select paa2.assignment_action_id,paa2.payroll_action_id
303: from pay_assignment_actions paa1,
304: pay_assignment_actions paa2
305: where paa1.assignment_action_id = c_assignment_action_id
306: and substr(paa1.serial_number,3,14) = paa2.assignment_action_id
307: and paa1.assignment_id = paa2.assignment_id;
308:

Line 455: from pay_assignment_actions paa

451: hr_utility.trace('In get_final_xml 20');
452:
453: select paa.payroll_action_id
454: into l_pa_id
455: from pay_assignment_actions paa
456: where paa.assignment_action_id = p_assignment_action_id;
457: hr_utility.trace('payroll_action_id '||l_pa_id);
458:
459: lv_negative_bal_flag := 'N';

Line 686: pay_assignment_actions paa

682:
683: cursor cur_gre_name is
684: select name
685: from hr_all_organization_units hou,
686: pay_assignment_actions paa
687: where paa.assignment_action_id = p_aa_id
688: and paa.tax_unit_id = hou.organization_id;
689:
690: begin