DBA Data[Home] [Help]

APPS.PY_ZA_TAX_REG dependencies on PAY_INPUT_VALUES_F

Line 469: , p_value_name IN pay_input_values_f.name%TYPE

465: -- run_result_value
466: -------------------------------------------------------------------------------
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

Line 485: , pay_input_values_f piv

481: prrv.result_value
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

Line 544: p_value_name IN pay_input_values_f.name%TYPE

540: -- run_result_value
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

Line 558: , pay_input_values_f piv

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
562: AND prr.element_type_id = piv.element_type_id