APPS.PQH_FR_PROGRESSION_POINT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE update_sal_rate_for_point(p_spinal_point_id in number,
                                    p_parent_spine_id in number,
                                    p_information_category in varchar2,
                                    p_information1    in varchar2,
                                    p_information1_o  in varchar2,
                                    p_information2    in varchar2,
                                    p_information2_o  in varchar2) IS

CURSOR csr_scale_type IS
 SELECT information_category,information1
 FROM   per_parent_spines
 WHERE  parent_spine_id = p_parent_spine_id;

Line: 18

   SELECT object_version_number
   FROM   pay_grade_rules_f
   WHERE  grade_rule_id = p_grd_rule_id
   AND    TRUNC(SYSDATE) between effective_start_date and effective_end_date;

Line: 42

    hr_utility.set_location('Leaving : pqh_fr_progression_point_pkg.update_sal_rate_for_point' , 10);

Line: 90

	   hr_rate_values_api.update_rate_value(p_grade_rule_id => l_hr_rate_id,
	                                        p_datetrack_mode => l_dt_upd_mode,
	                                        p_effective_date => TRUNC(SYSDATE),
	                                        p_value => l_new_rate,
	                                        p_object_version_number => l_ovn,
	                                        p_effective_start_date => l_esd,
	                                        p_effective_end_date => l_eed);

Line: 100

END update_sal_rate_for_point;