3554: -------------------------------------------------------------------------------
3555: PROCEDURE Trace AS
3556: BEGIN
3557:
3558: /*DELETE FROM pay_za_tax_traces pztt
3559: WHERE pztt.prl_act_id not in (
3560: SELECT payroll_action_id
3561: from pay_payroll_actions)
3562: */
3559: WHERE pztt.prl_act_id not in (
3560: SELECT payroll_action_id
3561: from pay_payroll_actions)
3562: */
3563: INSERT INTO pay_za_tax_traces(
3564: ASG_ACT_ID
3565: ,ASG_ID
3566: ,PRL_ACT_ID
3567: ,PRL_ID