APPS.PY_ZA_TAX_REG dependencies on PAY_ZA_IRP5_BAL_CODES

Line 297: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE

293: FUNCTION ptd_value (
294: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
295: , p_action_period_id IN per_time_periods.time_period_id%TYPE
296: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
297: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
298: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
299: )
300: RETURN NUMBER AS
301: ------------

Line 358: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE

354: -------------------------------------------------------------------------------
355: FUNCTION mtd_value (
356: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
357: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
358: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
359: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
360: )
361: RETURN NUMBER AS
362: ------------

Line 1583: FROM pay_za_irp5_bal_codes pbc

1579: SELECT DISTINCT
1580: pbc.full_balance_name bal_name
1581: , pbc.code bal_code
1582: , pbc.balance_type_id bal_id
1583: FROM pay_za_irp5_bal_codes pbc
1584: , pay_run_result_values prrv
1585: , pay_run_results prr
1586: , pay_balance_feeds_f feed
1587: , pay_payroll_actions ppa

Line 1616: l_bal_code pay_za_irp5_bal_codes.code%TYPE;

1612: l_mtd_bal NUMBER;
1613: l_ytd_bal NUMBER;
1614: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
1615: l_nature hr_lookups.meaning%TYPE;
1616: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
1617:
1618: l_ovn number; -- bug 13444804
1619: l_action_id number; -- bug 13444804
1620:

Line 2056: from pay_za_irp5_bal_codes

2052: ) as
2053: function get_bal_name (l_code number) return varchar2 is
2054: cursor csr_bal_name(l_code number) is
2055: select balance_name
2056: from pay_za_irp5_bal_codes
2057: where code = l_code;
2058: l_bal_name varchar2(100);
2059: begin
2060: if l_code = '4003' then

Line 2288: FROM pay_za_irp5_bal_codes pbc

2284: SELECT DISTINCT
2285: pbc.balance_name bal_name
2286: , pbc.code bal_code
2287: , pbc.balance_type_id bal_id
2288: FROM pay_za_irp5_bal_codes pbc
2289: , pay_run_result_values prrv
2290: , pay_run_results prr
2291: , pay_balance_feeds_f feed
2292: , pay_payroll_actions ppa

Line 2365: -- pay_za_irp5_bal_codes table where full balance name

2361: -- Cursor csr_balance_type_id_codes
2362: --
2363: -- fetches the balance_type_id and full_balance_name
2364: -- for codes 3915,3608,3707 and 3718 from
2365: -- pay_za_irp5_bal_codes table where full balance name
2366: -- contains RFI
2367: -----------------------------------------------------------
2368:
2369: Cursor csr_balance_details_codes is

Line 2371: from pay_za_irp5_bal_codes

2367: -----------------------------------------------------------
2368:
2369: Cursor csr_balance_details_codes is
2370: select code bal_code, balance_type_id bal_id, full_balance_name bal_name
2371: from pay_za_irp5_bal_codes
2372: where user_name like '%_ASG_LMPSM_TAX_YTD'
2373: and full_balance_name like '% RFI' ;
2374:
2375:

Line 2392: l_bal_code pay_za_irp5_bal_codes.code%TYPE;

2388: l_mtd_bal NUMBER;
2389: l_ytd_bal NUMBER;
2390: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
2391: l_nature hr_lookups.meaning%TYPE;
2392: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
2393: t_code_val code_value_table;
2394: l_code pay_za_irp5_bal_codes.code%TYPE;
2395: l_asg_foreign_income varchar2(1);
2396: l_4149_ptd NUMBER;

Line 2394: l_code pay_za_irp5_bal_codes.code%TYPE;

2390: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
2391: l_nature hr_lookups.meaning%TYPE;
2392: l_bal_code pay_za_irp5_bal_codes.code%TYPE;
2393: t_code_val code_value_table;
2394: l_code pay_za_irp5_bal_codes.code%TYPE;
2395: l_asg_foreign_income varchar2(1);
2396: l_4149_ptd NUMBER;
2397: l_4149_mtd NUMBER;
2398: l_4149_ytd NUMBER;