APPS.PY_ZA_TAX_REG dependencies on PAY_RUN_RESULTS

Line 414: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE

410: FUNCTION run_result_value (
411: p_element_name IN pay_element_types_f.element_name%TYPE
412: , p_value_name IN pay_input_values_f.name%TYPE
413: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
414: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE
415: )
416: RETURN pay_run_result_values.result_value%TYPE
417: AS
418: ---------

Line 429: , pay_run_results prr

425: , prrv.run_result_id
426: FROM
427: pay_element_types_f pet
428: , pay_input_values_f piv
429: , pay_run_results prr
430: , pay_run_result_values prrv
431: WHERE
432: pet.element_name = p_element_name
433: AND pet.legislation_code = 'ZA'

Line 444: pay_run_results prr2

440: (
441: SELECT
442: MAX(paa2.assignment_action_id)
443: FROM
444: pay_run_results prr2
445: , pay_assignment_actions paa2
446: , pay_payroll_actions ppa2
447: WHERE
448: prr2.element_type_id = pet.element_type_id

Line 488: , p_run_result_id IN pay_run_results.run_result_id%TYPE

484: -- Overloaded version of the function where the run_result_id us known
485: -------------------------------------------------------------------------------
486: FUNCTION run_result_value (
487: p_value_name IN pay_input_values_f.name%TYPE
488: , p_run_result_id IN pay_run_results.run_result_id%TYPE
489: )
490: RETURN pay_run_result_values.result_value%TYPE
491: AS
492: ---------

Line 500: pay_run_results prr

496: IS
497: SELECT
498: prrv.result_value
499: FROM
500: pay_run_results prr
501: , pay_input_values_f piv
502: , pay_run_result_values prrv
503: WHERE
504: prr.run_result_id = p_run_result_id

Line 592: l_run_result_id pay_run_results.run_result_id%TYPE;

588: -- Variables
589: ------------
590: l_tax_status hr_lookups.meaning%TYPE;
591: l_dir_value pay_run_result_values.result_value%TYPE;
592: l_run_result_id pay_run_results.run_result_id%TYPE;
593: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
594:
595: -------------------------------------------------------------------------------
596: BEGIN -- MAIN --

Line 1502: , pay_run_results prr

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
1505: , pay_assignment_actions paa
1506: WHERE prrv.input_value_id = feed.input_value_id