APPS.PER_GRADES_PKG dependencies on PAY_GRADE_RULES

Line 482: FROM pay_grade_rules

478: WHERE grade_id = p_grd_id;
479: --
480: cursor c7 is
481: select 'x'
482: FROM pay_grade_rules
483: WHERE grade_or_spinal_point_id = p_grd_id
484: AND rate_type = 'G';
485: --
486: begin

Line 596: UPDATE pay_grade_rules_f

592: BEGIN
593: l_exists := 'N';
594: IF p_seq <> p_s_seq THEN
595: BEGIN
596: UPDATE pay_grade_rules_f
597: SET sequence = p_seq,
598: last_update_date = SYSDATE,
599: last_updated_by = p_lastup,
600: last_update_login = p_login

Line 858: -- pay_grade_rules_f table.

854: l_exists varchar2(1);
855:
856: -- bug 4024588.
857: -- cursor modified to fetch only grade rate records from
858: -- pay_grade_rules_f table.
859:
860: cursor chk_grd_dt_from is
861: select 'x' from pay_grade_rules_f p
862: where p.grade_or_spinal_point_id = p_grade_id

Line 861: select 'x' from pay_grade_rules_f p

857: -- cursor modified to fetch only grade rate records from
858: -- pay_grade_rules_f table.
859:
860: cursor chk_grd_dt_from is
861: select 'x' from pay_grade_rules_f p
862: where p.grade_or_spinal_point_id = p_grade_id
863: and p.rate_type='G' -- Bug fix 4024588
864: and p.effective_start_date < nvl(p_date_from, hr_api.g_sot);
865: --

Line 888: select 'x' from pay_grade_rules_f p

884: p_date_to in date) is
885: l_exists varchar2(1);
886:
887: cursor chk_grd_dt_to is
888: select 'x' from pay_grade_rules_f p
889: where p.grade_or_spinal_point_id = p_grade_id
890: and p.rate_type='G' -- Bug fix 3360504. Type check added.
891: and p.effective_end_date > nvl(p_date_to, hr_api.g_eot);
892: