2940: -------------------------------------------------------------------------------
2941: PROCEDURE Trace AS
2942: BEGIN
2943:
2944: /*DELETE FROM pay_za_tax_traces pztt
2945: WHERE pztt.prl_act_id not in (
2946: SELECT payroll_action_id
2947: from pay_payroll_actions)
2948: */
2945: WHERE pztt.prl_act_id not in (
2946: SELECT payroll_action_id
2947: from pay_payroll_actions)
2948: */
2949: INSERT INTO pay_za_tax_traces(
2950: ASG_ACT_ID
2951: ,ASG_ID
2952: ,PRL_ACT_ID
2953: ,PRL_ID