APPS.PY_ZA_TAX_REG dependencies on PAY_ZA_IRP5_BAL_CODES

Line 242: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE

238: FUNCTION ptd_value (
239: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
240: , p_action_period_id IN per_time_periods.time_period_id%TYPE
241: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
242: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
243: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
244: )
245: RETURN NUMBER AS
246: ------------

Line 302: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE

298: -------------------------------------------------------------------------------
299: FUNCTION mtd_value (
300: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
301: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
302: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
303: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
304: )
305: RETURN NUMBER AS
306: ------------

Line 1500: FROM pay_za_irp5_bal_codes pbc

1496: SELECT DISTINCT
1497: pbc.full_balance_name bal_name
1498: , pbc.code bal_code
1499: , pbc.balance_type_id bal_id
1500: FROM pay_za_irp5_bal_codes pbc
1501: , pay_run_result_values prrv
1502: , pay_run_results prr
1503: , pay_balance_feeds_f feed
1504: , pay_payroll_actions ppa

Line 1530: l_bal_code pay_za_irp5_bal_codes.code%TYPE;

1526: l_mtd_bal NUMBER;
1527: l_ytd_bal NUMBER;
1528: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
1529: l_nature hr_lookups.meaning%TYPE;
1530: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
1531:
1532: -------------------------------------------------------------------------------
1533: BEGIN -- Pre Process - MAIN --
1534: -------------------------------------------------------------------------------