2849: -------------------------------------------------------------------------------
2850: PROCEDURE Trace AS
2851: BEGIN
2852:
2853: /*DELETE FROM pay_za_tax_traces pztt
2854: WHERE pztt.prl_act_id not in (
2855: SELECT payroll_action_id
2856: from pay_payroll_actions)
2857: */
2854: WHERE pztt.prl_act_id not in (
2855: SELECT payroll_action_id
2856: from pay_payroll_actions)
2857: */
2858: INSERT INTO pay_za_tax_traces(
2859: ASG_ACT_ID
2860: ,ASG_ID
2861: ,PRL_ACT_ID
2862: ,PRL_ID