[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);
186: p_prior_pay_rate_det_code in ('0','7')
187: )
188: ) then
189: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
190: '0000 Oracle Federal Standard Pay Table (AL, ES, EX, GS, GG) No. 0000',
191: 'GG' || '-' || p_prior_grade_or_level,
192: p_prior_step_or_rate,
193: p_prior_effective_date);
194: if not (
1629: it represents any percentage shown for the locality area, with the "as of date" of the
1630: file falling within the date range, on Table 25. (If a more percise check is needed,
1631: as is the case of area 41, a subsequent relationship edit will catch the error.)
1632: Locality pay is generated within CPDF according to the duty station. For definitions,
1633: see the Guide to Personnel Data Standards. */
1634: --
1635: --
1636: procedure chk_locality_adj
1637: (p_to_pay_plan in varchar2