APPS.PAY_CA_T4_XML dependencies on PAY_PAYROLL_ACTIONS

Line 261: l_report_type pay_payroll_actions.report_type%TYPE;

257: l_prov varchar2(240);
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);

Line 279: pay_payroll_actions ppa,

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
283: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 281: pay_payroll_actions ppa1

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')
285: and fnd_number.canonical_to_number(substr(paa.serial_number,3,14)) = paa1.assignment_action_id

Line 296: cursor c_get_report_type(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is

292: and ppa1.effective_date = ppa.effective_date;
293:
294: /*Added for Bug#10359114 */
295:
296: cursor c_get_report_type(c_payroll_action_id pay_payroll_actions.payroll_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:

Line 298: from pay_payroll_actions ppa

294: /*Added for Bug#10359114 */
295:
296: cursor c_get_report_type(c_payroll_action_id pay_payroll_actions.payroll_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