APPS.PY_ZA_TAX_REG dependencies on PAY_RUN_RESULTS

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

467: FUNCTION run_result_value (
468: p_element_name IN pay_element_types_f.element_name%TYPE
469: , p_value_name IN pay_input_values_f.name%TYPE
470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
471: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE
472: )
473: RETURN pay_run_result_values.result_value%TYPE
474: AS
475: ---------

Line 486: , pay_run_results prr

482: , prrv.run_result_id
483: FROM
484: pay_element_types_f pet
485: , pay_input_values_f piv
486: , pay_run_results prr
487: , pay_run_result_values prrv
488: WHERE
489: pet.element_name = p_element_name
490: AND pet.legislation_code = 'ZA'

Line 501: pay_run_results prr2

497: (
498: SELECT
499: MAX(paa2.assignment_action_id)
500: FROM
501: pay_run_results prr2
502: , pay_assignment_actions paa2
503: , pay_payroll_actions ppa2
504: WHERE
505: prr2.element_type_id = pet.element_type_id

Line 545: , p_run_result_id IN pay_run_results.run_result_id%TYPE

541: -- Overloaded version of the function where the run_result_id us known
542: -------------------------------------------------------------------------------
543: FUNCTION run_result_value (
544: p_value_name IN pay_input_values_f.name%TYPE
545: , p_run_result_id IN pay_run_results.run_result_id%TYPE
546: )
547: RETURN pay_run_result_values.result_value%TYPE
548: AS
549: ---------

Line 557: pay_run_results prr

553: IS
554: SELECT
555: prrv.result_value
556: FROM
557: pay_run_results prr
558: , pay_input_values_f piv
559: , pay_run_result_values prrv
560: WHERE
561: prr.run_result_id = p_run_result_id

Line 649: l_run_result_id pay_run_results.run_result_id%TYPE;

645: -- Variables
646: ------------
647: l_tax_status hr_lookups.meaning%TYPE;
648: l_dir_value pay_run_result_values.result_value%TYPE;
649: l_run_result_id pay_run_results.run_result_id%TYPE;
650: l_asg_tax_status_code hr_lookups.lookup_code%TYPE;
651:
652: -------------------------------------------------------------------------------
653: BEGIN -- MAIN --

Line 1585: , pay_run_results prr

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

Line 2290: , pay_run_results prr

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

Line 2319: , pay_run_results prr

2315: , decode(pbt.balance_name,'Skills Levy',4142,4141) bal_code
2316: , pbt.balance_type_id bal_id
2317: FROM pay_balance_types pbt
2318: , pay_run_result_values prrv
2319: , pay_run_results prr
2320: , pay_balance_feeds_f feed
2321: , pay_payroll_actions ppa
2322: , pay_assignment_actions paa
2323: WHERE prrv.input_value_id = feed.input_value_id