[Home] [Help]
31: hr_utility.set_location('eff date '|| p_prior_effective_date,1);
32: hr_utility.set_location('grade '|| p_prior_grade_or_level,1);
33: hr_utility.set_location('Step '|| p_prior_step_or_rate,1);
34: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
35: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',
36: 'GS' || '-' || p_prior_grade_or_level,
37: p_prior_step_or_rate,
38: p_prior_effective_date);
39: hr_utility.set_location('after call to get basic pay',1);
183: p_prior_pay_rate_det_code in ('0','7')
184: )
185: ) then
186: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
187: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',
188: 'GG' || '-' || p_prior_grade_or_level,
189: p_prior_step_or_rate,
190: p_prior_effective_date);
191: if not (
1554: it represents any percentage shown for the locality area, with the "as of date" of the
1555: file falling within the date range, on Table 25. (If a more percise check is needed,
1556: as is the case of area 41, a subsequent relationship edit will catch the error.)
1557: Locality pay is generated within CPDF according to the duty station. For definitions,
1558: see the Guide to Personnel Data Standards. */
1559: --
1560: --
1561: procedure chk_locality_adj
1562: (p_to_pay_plan in varchar2