APPS.HR_CHANGE_START_DATE_API dependencies on PAY_GRADE_RULES_F

Line 582: from pay_grade_rules_f pgr,

578: ,p_type VARCHAR2) is
579: cursor csr_asg_rates_pdp is
580: select 'x' from dual where exists
581: (select 1
582: from pay_grade_rules_f pgr,
583: per_periods_of_placement p,
584: per_assignments_f a
585: where a.person_id = p_person_id
586: and a.period_of_placement_date_start = p.date_start

Line 1400: from pay_grade_rules_f pgr

1396: ,p_new_start_date date
1397: ,p_type VARCHAR2) is
1398: cursor csr_rate is
1399: select grade_rule_id
1400: from pay_grade_rules_f pgr
1401: where grade_or_spinal_point_id in (select a.assignment_id
1402: from per_assignments_f a
1403: where person_id = p_person_id
1404: and a.assignment_type = p_type

Line 1409: l_pgr_id pay_grade_rules_f.grade_rule_id%TYPE;

1405: and a.effective_start_date = p_old_start_date)
1406: and pgr.rate_type = 'A'
1407: and pgr.effective_start_date = p_old_start_date;
1408: --
1409: l_pgr_id pay_grade_rules_f.grade_rule_id%TYPE;
1410: --
1411: begin
1412: open csr_rate;
1413: loop

Line 1416: update pay_grade_rules_f

1412: open csr_rate;
1413: loop
1414: fetch csr_rate into l_pgr_id;
1415: exit when csr_rate%NOTFOUND;
1416: update pay_grade_rules_f
1417: set effective_start_date = p_new_start_date
1418: where effective_start_date = p_old_start_date
1419: and grade_rule_id = l_pgr_id;
1420: if sql%rowcount <1 then

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

1418: where effective_start_date = p_old_start_date
1419: and grade_rule_id = l_pgr_id;
1420: if sql%rowcount <1 then
1421: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1422: hr_utility.set_message_token('TABLE','PAY_GRADE_RULES_F');
1423: hr_utility.raise_error;
1424: end if;
1425: end loop;
1426: close csr_rate;