3539: -------------------------------------------------------------------------------
3540: PROCEDURE Trace AS
3541: BEGIN
3542:
3543: /*DELETE FROM pay_za_tax_traces pztt
3544: WHERE pztt.prl_act_id not in (
3545: SELECT payroll_action_id
3546: from pay_payroll_actions)
3547: */
3544: WHERE pztt.prl_act_id not in (
3545: SELECT payroll_action_id
3546: from pay_payroll_actions)
3547: */
3548: INSERT INTO pay_za_tax_traces(
3549: ASG_ACT_ID
3550: ,ASG_ID
3551: ,PRL_ACT_ID
3552: ,PRL_ID