APPS.PY_ZA_TX_UTL_01032013 dependencies on PAY_PAYROLL_ACTIONS

Line 567: FROM pay_payroll_actions ppa

563: ELSE
564: hr_utility.set_location('py_za_tx_utl_01032013.PeriodFactor',4);
565: SELECT count(ptp_all.PERIOD_NAME)
566: INTO l_no_of_periods
567: FROM pay_payroll_actions ppa
568: ,per_time_periods ptp
569: ,per_time_periods ptp_all
570: where ppa.payroll_action_id = py_za_tx_01032013.con_PRL_ACT_ID
571: and ppa.time_period_id = ptp.time_period_id

Line 579: FROM pay_payroll_actions ppa

575: and py_za_tx_01032013.dbi_ZA_ACT_STRT_DTE <= ptp_all.end_date;
576:
577: SELECT min(ptp_all.end_date ) - min(py_za_tx_01032013.dbi_ZA_ACT_STRT_DTE)+1
578: INTO l_no_of_days
579: FROM pay_payroll_actions ppa
580: ,per_time_periods ptp
581: ,per_time_periods ptp_all
582: where ppa.payroll_action_id = py_za_tx_01032013.con_PRL_ACT_ID
583: and ppa.time_period_id = ptp.time_period_id

Line 2770: l_effective_date pay_payroll_actions.effective_date%TYPE;

2766: --
2767: l_fixed pay_user_column_instances_f.value%TYPE;
2768: l_limit pay_user_column_instances_f.value%TYPE;
2769: l_percentage pay_user_column_instances_f.value%TYPE;
2770: l_effective_date pay_payroll_actions.effective_date%TYPE;
2771: tax_liability t_Balance;
2772: l_TxbAmt t_Balance;
2773: --
2774: BEGIN

Line 3705: from pay_payroll_actions)

3701:
3702: /*DELETE FROM pay_za_tax_traces pztt
3703: WHERE pztt.prl_act_id not in (
3704: SELECT payroll_action_id
3705: from pay_payroll_actions)
3706: */
3707: INSERT INTO pay_za_tax_traces(
3708: ASG_ACT_ID
3709: ,ASG_ID