DBA Data[Home] [Help]

APPS.PY_ZA_TAX_REG dependencies on PAY_INPUT_VALUES_F

Line 412: , p_value_name IN pay_input_values_f.name%TYPE

408: -- run_result_value
409: -------------------------------------------------------------------------------
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

Line 428: , pay_input_values_f piv

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

Line 487: p_value_name IN pay_input_values_f.name%TYPE

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

Line 501: , pay_input_values_f piv

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