89: FROM
90: per_all_people_f ppf,
91: per_all_assignments_f paf,
92: pay_action_interlocks pai,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: pay_assignment_actions paa_arch,
96: pay_payroll_actions ppa_arch
97: WHERE
91: per_all_assignments_f paf,
92: pay_action_interlocks pai,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: pay_assignment_actions paa_arch,
96: pay_payroll_actions ppa_arch
97: WHERE
98: ppa.payroll_action_id =
99: to_number(pay_magtape_generic.get_parameter_value
185: from sys.dual;
186:
187: cursor rl1xml_transfer_block is
188: select 'TRANSFER_ACT_ID=P', assignment_action_id
189: from pay_assignment_actions
190: where payroll_action_id =
191: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
192:
193: PROCEDURE RL1XML_emplyer_data(p_assact_id IN NUMBER