APPS.PY_ZA_TX_UTL_01032004 dependencies on PAY_PAYROLL_ACTIONS

Line 2451: l_effective_date pay_payroll_actions.effective_date%TYPE;

2447: --
2448: l_fixed pay_user_column_instances_f.value%TYPE;
2449: l_limit pay_user_column_instances_f.value%TYPE;
2450: l_percentage pay_user_column_instances_f.value%TYPE;
2451: l_effective_date pay_payroll_actions.effective_date%TYPE;
2452: tax_liability t_Balance;
2453: l_TxbAmt t_Balance;
2454:
2455: BEGIN

Line 3370: from pay_payroll_actions)

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: */
3372: INSERT INTO pay_za_tax_traces(
3373: ASG_ACT_ID
3374: ,ASG_ID