APPS.PY_ZA_TX_01011001 dependencies on PAY_PAYROLL_ACTIONS

Line 1482: l_effective_date pay_payroll_actions.effective_date%TYPE;

1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;
1480: l_limit pay_user_column_instances_f.value%TYPE;
1481: l_percentage pay_user_column_instances_f.value%TYPE;
1482: l_effective_date pay_payroll_actions.effective_date%TYPE;
1483: tax_liability NUMBER(15,2);
1484: l_TxbAmt NUMBER(15,2);
1485:
1486: BEGIN

Line 1503: FROM pay_payroll_actions ppa

1499:
1500: /* this selects the effective date for the payroll_run*/
1501: SELECT ppa.effective_date
1502: INTO l_effective_date
1503: FROM pay_payroll_actions ppa
1504: WHERE ppa.payroll_action_id = con_PRL_ACT_ID;
1505:
1506:
1507: /* Selects to get the relevant id's */

Line 2266: from pay_payroll_actions)

2262:
2263: /*DELETE FROM pay_za_tax_traces pztt
2264: WHERE pztt.prl_act_id not in (
2265: SELECT payroll_action_id
2266: from pay_payroll_actions)
2267: */
2268: INSERT INTO pay_za_tax_traces(
2269: ASG_ACT_ID
2270: ,ASG_ID