APPS.HR_CHANGE_START_DATE_API dependencies on PAY_GRADE_RULES_F

Line 523: from pay_grade_rules_f pgr,

519: ,p_type VARCHAR2) is
520: cursor csr_asg_rates_pdp is
521: select 'x' from dual where exists
522: (select 1
523: from pay_grade_rules_f pgr,
524: per_periods_of_placement p,
525: per_assignments_f a
526: where a.person_id = p_person_id
527: and a.period_of_placement_date_start = p.date_start

Line 1052: from pay_grade_rules_f pgr

1048: ,p_new_start_date date
1049: ,p_type VARCHAR2) is
1050: cursor csr_rate is
1051: select grade_rule_id
1052: from pay_grade_rules_f pgr
1053: where grade_or_spinal_point_id in (select a.assignment_id
1054: from per_assignments_f a
1055: where person_id = p_person_id
1056: and a.assignment_type = p_type

Line 1061: l_pgr_id pay_grade_rules_f.grade_rule_id%TYPE;

1057: and a.effective_start_date = p_old_start_date)
1058: and pgr.rate_type = 'A'
1059: and pgr.effective_start_date = p_old_start_date;
1060: --
1061: l_pgr_id pay_grade_rules_f.grade_rule_id%TYPE;
1062: --
1063: begin
1064: open csr_rate;
1065: loop

Line 1068: update pay_grade_rules_f

1064: open csr_rate;
1065: loop
1066: fetch csr_rate into l_pgr_id;
1067: exit when csr_rate%NOTFOUND;
1068: update pay_grade_rules_f
1069: set effective_start_date = p_new_start_date
1070: where effective_start_date = p_old_start_date
1071: and grade_rule_id = l_pgr_id;
1072: if sql%rowcount <1 then

Line 1074: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');

1070: where effective_start_date = p_old_start_date
1071: and grade_rule_id = l_pgr_id;
1072: if sql%rowcount <1 then
1073: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1074: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1075: hr_utility.raise_error;
1076: end if;
1077: end loop;
1078: close csr_rate;