DBA Data[Home] [Help]

APPS.PER_ZA_UTILITY_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 910: ,p_result_value IN pay_run_result_values.result_value%TYPE

906:
907: PROCEDURE insert_rr_value (
908: p_input_value_id IN pay_input_values_f.input_value_id%TYPE
909: ,p_run_result_id IN pay_run_results.run_result_id%TYPE
910: ,p_result_value IN pay_run_result_values.result_value%TYPE
911: )
912: AS
913: ------------
914: -- Variable

Line 957: insert into pay_run_result_values (

953: and rownum = 1;
954:
955: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',2);
956:
957: insert into pay_run_result_values (
958: INPUT_VALUE_ID
959: ,RUN_RESULT_ID
960: ,RESULT_VALUE)
961: (select

Line 967: from pay_run_result_values

963: ,p_run_result_id
964: ,p_result_value
965: from dual
966: where not exists ( select null
967: from pay_run_result_values
968: where INPUT_VALUE_ID = p_input_value_id
969: and run_result_id = p_run_result_id
970: )
971: );