3363: -------------------------------------------------------------------------------
3364: PROCEDURE Trace AS
3365: BEGIN
3366:
3367: /*DELETE FROM pay_za_tax_traces pztt
3368: WHERE pztt.prl_act_id not in (
3369: SELECT payroll_action_id
3370: from pay_payroll_actions)
3371: */
3368: WHERE pztt.prl_act_id not in (
3369: SELECT payroll_action_id
3370: from pay_payroll_actions)
3371: */
3372: INSERT INTO pay_za_tax_traces(
3373: ASG_ACT_ID
3374: ,ASG_ID
3375: ,PRL_ACT_ID
3376: ,PRL_ID