APPS.PER_ZA_UTILITY_PKG dependencies on PAY_INPUT_VALUES_F

Line 750: , pay_input_values_f piv

746: , piv.min_value
747: , piv.warning_or_error
748: from
749: pay_element_links_f pel
750: , pay_input_values_f piv
751: , pay_element_types_f pet
752: where
753: pet.element_type_id = pel.element_type_id
754: and pet.element_type_id = piv.element_type_id

Line 908: p_input_value_id IN pay_input_values_f.input_value_id%TYPE

904: -- Procedure inserts input value for a perticular run result and input value
905: ----------------------------------------------------------------------------
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

Line 922: l_input_value_name pay_input_values_f.name%TYPE;

918: l_clar_no_con number;
919: l_Dir_no_con varchar2(60);
920: l_clar_no number;
921: l_Dir_no varchar2(60);
922: l_input_value_name pay_input_values_f.name%TYPE;
923:
924:
925: -- Cursors
926:

Line 951: from pay_input_values_f pivf

947: fetch cur_run_res_con into cur_run_res_con_rec;
948:
949: select pivf.name
950: into l_input_value_name
951: from pay_input_values_f pivf
952: where pivf.INPUT_VALUE_ID = p_input_value_id
953: and rownum = 1;
954:
955: hr_utility.set_location('per_za_utility_pkg.insert_rr_value',2);