93: FROM
94: per_all_people_f ppf,
95: per_all_assignments_f paf,
96: pay_action_interlocks pai,
97: pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: pay_assignment_actions paa_arch
100: WHERE
101: ppa.payroll_action_id =
95: per_all_assignments_f paf,
96: pay_action_interlocks pai,
97: pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: pay_assignment_actions paa_arch
100: WHERE
101: ppa.payroll_action_id =
102: to_number(pay_magtape_generic.get_parameter_value
103: ('TRANSFER_PAYROLL_ACTION_ID')) AND
196: from sys.dual;
197:
198: cursor rl1xml_transfer_block is
199: select 'TRANSFER_ACT_ID=P', assignment_action_id
200: from pay_assignment_actions
201: where payroll_action_id =
202: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
203:
204: PROCEDURE RL1XML_emplyer_data(p_assact_id IN NUMBER