eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_CHECK7 dependencies on GHR_CPDF_CHECK

Line 1: package body GHR_CPDF_CHECK7 as

1: package body GHR_CPDF_CHECK7 as
2: /* $Header: ghcpdf07.pkb 120.29 2011/10/27 07:15:54 utokachi ship $ */
3:
4: max_basic_pay number(10,2);
5: min_basic_pay number(10,2);

Line 34: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(

30: hr_utility.set_location('before call to get basic pay',1);
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);

Line 189: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(

185: p_prior_step_or_rate between '01' and '10' and
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);

Line 214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',

210: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
211: p_prior_pay_plan = 'NH' and
212: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
213: if p_prior_pay_rate_det_code in ('0','7') then
214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
215: p_prior_grade_or_level ,
216: 'Minimum Basic Pay',p_effective_date);
217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
218: p_prior_grade_or_level ,

Line 217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',

213: if p_prior_pay_rate_det_code in ('0','7') then
214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
215: p_prior_grade_or_level ,
216: 'Minimum Basic Pay',p_effective_date);
217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
218: p_prior_grade_or_level ,
219: 'Maximum Basic Pay',p_effective_date);
220: elsif p_prior_pay_rate_det_code in ('5','6') then
221: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',

Line 221: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',

217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
218: p_prior_grade_or_level ,
219: 'Maximum Basic Pay',p_effective_date);
220: elsif p_prior_pay_rate_det_code in ('5','6') then
221: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
222: p_prior_grade_or_level ,
223: 'Minimum Basic Pay',p_effective_date);
224: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
225: p_prior_grade_or_level ,

Line 224: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',

220: elsif p_prior_pay_rate_det_code in ('5','6') then
221: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
222: p_prior_grade_or_level ,
223: 'Minimum Basic Pay',p_effective_date);
224: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
225: p_prior_grade_or_level ,
226: 'Maximum Basic Pay',p_effective_date);
227: end if;
228: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 252: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',

248: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
249: if p_prior_pay_plan = 'GS' and
250: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
251:
252: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
253: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
254: 'Minimum Basic Pay',
255: p_prior_effective_date);
256: if min_basic_pay IS NOT NULL and

Line 278: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',

274: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
275: p_prior_pay_plan = 'NJ' and
276: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
277: if p_prior_pay_rate_det_code in ('0','7') then
278: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
279: p_prior_grade_or_level ,
280: 'Minimum Basic Pay',p_effective_date);
281: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
282: p_prior_grade_or_level ,

Line 281: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',

277: if p_prior_pay_rate_det_code in ('0','7') then
278: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
279: p_prior_grade_or_level ,
280: 'Minimum Basic Pay',p_effective_date);
281: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
282: p_prior_grade_or_level ,
283: 'Maximum Basic Pay',p_effective_date);
284: elsif p_prior_pay_rate_det_code in ('5','6') then
285: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',

Line 285: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',

281: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
282: p_prior_grade_or_level ,
283: 'Maximum Basic Pay',p_effective_date);
284: elsif p_prior_pay_rate_det_code in ('5','6') then
285: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
286: p_prior_grade_or_level ,
287: 'Minimum Basic Pay',p_effective_date);
288: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
289: p_prior_grade_or_level ,

Line 288: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',

284: elsif p_prior_pay_rate_det_code in ('5','6') then
285: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
286: p_prior_grade_or_level ,
287: 'Minimum Basic Pay',p_effective_date);
288: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
289: p_prior_grade_or_level ,
290: 'Maximum Basic Pay',p_effective_date);
291: end if;
292: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 314: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',

310: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
311: p_prior_pay_plan = 'NK' and
312: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
313: if p_prior_pay_rate_det_code in ('0','7') then
314: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
315: p_prior_grade_or_level ,
316: 'Minimum Basic Pay',p_effective_date);
317: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
318: p_prior_grade_or_level ,

Line 317: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',

313: if p_prior_pay_rate_det_code in ('0','7') then
314: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
315: p_prior_grade_or_level ,
316: 'Minimum Basic Pay',p_effective_date);
317: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
318: p_prior_grade_or_level ,
319: 'Maximum Basic Pay',p_effective_date);
320: elsif p_prior_pay_rate_det_code in ('5','6') then
321: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',

Line 321: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',

317: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
318: p_prior_grade_or_level ,
319: 'Maximum Basic Pay',p_effective_date);
320: elsif p_prior_pay_rate_det_code in ('5','6') then
321: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
322: p_prior_grade_or_level ,
323: 'Minimum Basic Pay',p_effective_date);
324: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
325: p_prior_grade_or_level ,

Line 324: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',

320: elsif p_prior_pay_rate_det_code in ('5','6') then
321: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
322: p_prior_grade_or_level ,
323: 'Minimum Basic Pay',p_effective_date);
324: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
325: p_prior_grade_or_level ,
326: 'Maximum Basic Pay',p_effective_date);
327: end if;
328: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 352: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

348: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
349: if p_prior_pay_plan = 'GM' and
350: p_prior_pay_rate_det_code in ('0','7') then
351:
352: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
353: p_prior_grade_or_level ,
354: 'Minimum Basic Pay',
355: p_prior_effective_date);
356:

Line 357: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

353: p_prior_grade_or_level ,
354: 'Minimum Basic Pay',
355: p_prior_effective_date);
356:
357: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
358: p_prior_grade_or_level ,
359: 'Maximum Basic Pay',
360: p_prior_effective_date);
361: if min_basic_pay IS NOT NULL and

Line 375: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

371: else
372: if p_prior_pay_plan = 'GM' and
373: p_prior_pay_rate_det_code in ('0','7') then
374:
375: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
376: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
377: 'Minimum Basic Pay',
378: p_prior_effective_date);
379:

Line 380: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

376: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
377: 'Minimum Basic Pay',
378: p_prior_effective_date);
379:
380: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
381: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
382: 'Maximum Basic Pay',
383: p_prior_effective_date);
384: if min_basic_pay IS NOT NULL and

Line 411: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',

407:
408: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
409: if p_prior_pay_plan in ('GH', 'GM') and
410: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
411: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
412: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
413: 'Minimum Basic Pay',
414: p_prior_effective_date);
415: if min_basic_pay IS NOT NULL and

Line 428: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',

424: end if;
425: else
426: if p_prior_pay_plan in ('GH', 'GM','GS') and
427: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
428: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
429: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
430: 'Minimum Basic Pay',
431: p_prior_effective_date);
432: if min_basic_pay IS NOT NULL and

Line 454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',

450: basic pay.*/
451: if p_prior_pay_plan = 'EX' and
452: p_prior_pay_rate_det_code = '0' then
453:
454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',
455: p_prior_grade_or_level,
456: 'Maximum Basic Pay',
457: p_prior_effective_date);
458: if max_basic_pay IS NOT NULL and

Line 485: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',

481:
482: if (p_prior_pay_plan in ('ES', 'FE') and
483: p_prior_pay_rate_det_code <> 'C' ) then
484:
485: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
486: p_prior_step_or_rate,
487: 'Maximum Basic Pay',
488: p_prior_effective_date);
489: if max_basic_pay IS NOT NULL and

Line 512: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',

508: IF ( p_effective_date >= to_date('2004/01/11', 'yyyy/mm/dd') )
509: and
510: ( p_prior_pay_plan in ('ES', 'FE') and p_prior_pay_rate_det_code <> 'C' )
511: THEN
512: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',
513: p_prior_pay_plan,
514: 'Minimum Basic Pay',
515: p_effective_date);
516: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',

Line 516: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',

512: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',
513: p_prior_pay_plan,
514: 'Minimum Basic Pay',
515: p_effective_date);
516: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',
517: p_prior_pay_plan,
518: 'Maximum Basic Pay',
519: p_effective_date);
520:

Line 548: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

544: min_basic_pay := NULL;
545: max_basic_pay := NULL;
546: if substr(p_prior_pay_plan,1,1) = 'W' then
547: if p_prior_pay_plan not in ('WG','WL','WM','WS') then
548: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
549: p_prior_pay_plan,
550: 'Maximum Basic Pay', p_prior_effective_date);
551: else
552: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

Line 552: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

548: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
549: p_prior_pay_plan,
550: 'Maximum Basic Pay', p_prior_effective_date);
551: else
552: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
553: p_prior_pay_plan||'-'||p_prior_grade_or_level,
554: 'Minimum Basic Pay', p_prior_effective_date);
555: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
556: p_prior_pay_plan||'-'||p_prior_grade_or_level,

Line 555: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

551: else
552: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
553: p_prior_pay_plan||'-'||p_prior_grade_or_level,
554: 'Minimum Basic Pay', p_prior_effective_date);
555: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
556: p_prior_pay_plan||'-'||p_prior_grade_or_level,
557: 'Maximum Basic Pay', p_prior_effective_date);
558: end if;
559: else

Line 561: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

557: 'Maximum Basic Pay', p_prior_effective_date);
558: end if;
559: else
560: if p_prior_pay_plan = 'XE' then
561: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
562: p_prior_pay_plan,
563: 'Minimum Basic Pay', p_prior_effective_date);
564: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
565: p_prior_pay_plan,

Line 564: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

560: if p_prior_pay_plan = 'XE' then
561: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
562: p_prior_pay_plan,
563: 'Minimum Basic Pay', p_prior_effective_date);
564: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
565: p_prior_pay_plan,
566: 'Maximum Basic Pay', p_prior_effective_date);
567: elsif p_prior_pay_plan in ('XF', 'XG', 'XH') then
568: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

Line 568: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

564: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
565: p_prior_pay_plan,
566: 'Maximum Basic Pay', p_prior_effective_date);
567: elsif p_prior_pay_plan in ('XF', 'XG', 'XH') then
568: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
569: p_prior_pay_plan||'-'||p_prior_grade_or_level,
570: 'Minimum Basic Pay', p_prior_effective_date);
571: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
572: p_prior_pay_plan||'-'||p_prior_grade_or_level,

Line 571: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

567: elsif p_prior_pay_plan in ('XF', 'XG', 'XH') then
568: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
569: p_prior_pay_plan||'-'||p_prior_grade_or_level,
570: 'Minimum Basic Pay', p_prior_effective_date);
571: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
572: p_prior_pay_plan||'-'||p_prior_grade_or_level,
573: 'Maximum Basic Pay', p_prior_effective_date);
574: end if;
575: end if;

Line 600: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(

596: IF p_effective_date >= fnd_date.canonical_to_date('2007/08/13') THEN
597: IF (
598: p_prior_pay_plan = 'GL' and p_prior_pay_rate_det_code in ('0','7')
599: ) THEN
600: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
601: '0491 Oracle Federal Special Rate Pay Table (GS) No. 0491',
602: 'GL' || '-' || p_prior_grade_or_level,
603: p_prior_step_or_rate,
604: p_prior_effective_date);

Line 629: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

625: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
626: -------------------------------------------------------------------------------
627: IF p_prior_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
628: if p_prior_pay_plan = 'KA' then
629: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
630: p_prior_pay_plan ,
631: 'Minimum Basic Pay',
632: p_prior_effective_date);
633: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

Line 633: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

629: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
630: p_prior_pay_plan ,
631: 'Minimum Basic Pay',
632: p_prior_effective_date);
633: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
634: p_prior_pay_plan ,
635: 'Maximum Basic Pay',
636: p_prior_effective_date);
637: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

Line 660: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',

656: -- Madhuri 19-MAY-2004 End dated the Edit as of 10-JAN-04
657: --
658: IF p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') then
659: if p_prior_pay_plan in ('FB', 'FJ', 'FX') then
660: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
661: '01',
662: 'Maximum Basic Pay',
663: p_prior_effective_date);
664: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',

Line 664: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',

660: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
661: '01',
662: 'Maximum Basic Pay',
663: p_prior_effective_date);
664: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
665: '06',
666: 'Maximum Basic Pay',
667: p_prior_effective_date);
668:

Line 690: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

686: basic pay.*/
687: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
688: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
689: if p_prior_pay_plan = 'FT' then
690: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
691: p_prior_pay_plan ,
692: 'Minimum Basic Pay',
693: p_prior_effective_date);
694: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

Line 694: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

690: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
691: p_prior_pay_plan ,
692: 'Minimum Basic Pay',
693: p_prior_effective_date);
694: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
695: p_prior_pay_plan ,
696: 'Maximum Basic Pay',
697: p_prior_effective_date);
698: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

Line 723: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

719: -- 18/10/2004 Madhuri From the start of the edit Deleting the edit
720: -----------------------------------------------------------------------------------------------------------
721:
722: /*if p_prior_pay_plan in ('FL', 'FS', 'FW') then
723: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
724: 'WG'||'-'||p_prior_grade_or_level,
725: 'Minimum Basic Pay',p_prior_effective_date);
726: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
727: 'WS'||'-'||p_prior_grade_or_level,

Line 726: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

722: /*if p_prior_pay_plan in ('FL', 'FS', 'FW') then
723: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
724: 'WG'||'-'||p_prior_grade_or_level,
725: 'Minimum Basic Pay',p_prior_effective_date);
726: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
727: 'WS'||'-'||p_prior_grade_or_level,
728: 'Maximum Basic Pay',p_prior_effective_date);
729:
730: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

Line 756: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

752: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
753: if p_prior_pay_plan = 'FM' and
754: p_prior_pay_rate_det_code in ('0','7') then
755:
756: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
757: p_prior_grade_or_level ,
758: 'Minimum Basic Pay',p_prior_effective_date);
759: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
760: p_prior_grade_or_level ,

Line 759: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

755:
756: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
757: p_prior_grade_or_level ,
758: 'Minimum Basic Pay',p_prior_effective_date);
759: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
760: p_prior_grade_or_level ,
761: 'Maximum Basic Pay',p_prior_effective_date);
762: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
763: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

Line 775: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

771: else
772: if p_prior_pay_plan = 'FM' and
773: p_prior_pay_rate_det_code in ('0','7') then
774:
775: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
776: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
777: 'Minimum Basic Pay',p_prior_effective_date);
778: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
779: p_prior_grade_or_level || '-' || p_prior_step_or_rate,

Line 778: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

774:
775: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
776: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
777: 'Minimum Basic Pay',p_prior_effective_date);
778: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
779: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
780: 'Maximum Basic Pay',p_prior_effective_date);
781: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
782: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

Line 804: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',

800: basic pay.
801: if p_prior_pay_plan = 'DR' and
802: p_prior_pay_rate_det_code in ('0','7') then
803:
804: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
805: p_prior_grade_or_level ,
806: 'Minimum Basic Pay',p_prior_effective_date);
807: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
808: p_prior_grade_or_level ,

Line 807: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',

803:
804: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
805: p_prior_grade_or_level ,
806: 'Minimum Basic Pay',p_prior_effective_date);
807: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
808: p_prior_grade_or_level ,
809: 'Maximum Basic Pay',p_prior_effective_date);
810:
811: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 834: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',

830: basic pay.
831: if p_prior_pay_plan = 'DR' and
832: p_prior_pay_rate_det_code in ('5','6') then
833:
834: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
835: p_prior_grade_or_level ,
836: 'Minimum Basic Pay',p_prior_effective_date);
837: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
838: p_prior_grade_or_level ,

Line 837: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',

833:
834: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
835: p_prior_grade_or_level ,
836: 'Minimum Basic Pay',p_prior_effective_date);
837: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
838: p_prior_grade_or_level ,
839: 'Maximum Basic Pay',p_prior_effective_date);
840: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
841: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

Line 860: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',

856: basic pay.*/
857: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
858: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
859: if p_prior_pay_plan = 'NY' then
860: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
861: p_prior_grade_or_level ,
862: 'Minimum Basic Pay',p_prior_effective_date);
863: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
864: p_prior_grade_or_level ,

Line 863: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',

859: if p_prior_pay_plan = 'NY' then
860: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
861: p_prior_grade_or_level ,
862: 'Minimum Basic Pay',p_prior_effective_date);
863: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
864: p_prior_grade_or_level ,
865: 'Maximum Basic Pay',p_prior_effective_date);
866: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
867: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

Line 886: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',

882: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
883: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
884: if p_prior_pay_plan = 'NX' then
885:
886: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
887: p_prior_grade_or_level ,
888: 'Minimum Basic Pay',p_prior_effective_date);
889: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
890: p_prior_grade_or_level ,

Line 889: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',

885:
886: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
887: p_prior_grade_or_level ,
888: 'Minimum Basic Pay',p_prior_effective_date);
889: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
890: p_prior_grade_or_level ,
891: 'Maximum Basic Pay',p_prior_effective_date);
892:
893: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 921: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

917: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
918: if p_prior_pay_plan = 'FC' and
919: p_prior_pay_rate_det_code <> 'C' then
920:
921: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
922: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
923: 'Minimum Basic Pay',p_prior_effective_date);
924:
925: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

Line 925: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

921: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
922: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
923: 'Minimum Basic Pay',p_prior_effective_date);
924:
925: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
926: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
927: 'Maximum Basic Pay',p_prior_effective_date);
928:
929: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 948: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',

944: basic pay.*/
945: if p_prior_pay_plan in ('AF','FO','FP') and
946: p_prior_pay_rate_det_code <> 'C' then
947:
948: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
949: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
950: 'Minimum Basic Pay',p_prior_effective_date);
951: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
952: p_prior_grade_or_level || '-' || p_prior_step_or_rate,

Line 951: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',

947:
948: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
949: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
950: 'Minimum Basic Pay',p_prior_effective_date);
951: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
952: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
953: 'Maximum Basic Pay',p_prior_effective_date);
954: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
955: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

Line 987: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',

983: p_agency_subelement = 'ST' and
984: p_prior_pay_rate_det_code = '0' and
985: p_prior_grade_or_level in ('13','14') then
986:
987: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',
988: p_prior_step_or_rate,
989: 'Maximum Basic Pay',
990: p_prior_effective_date);
991:

Line 1014: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',

1010: /* Commenting the edit as per the Bug 3147737.
1011: if p_prior_pay_plan = 'GS' and
1012: p_prior_pay_rate_det_code in ('5','6','M') then
1013:
1014: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
1015: p_prior_grade_or_level,
1016: 'Maximum Basic Pay',
1017: p_prior_effective_date);
1018:

Line 1046: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',

1042: if p_prior_pay_plan = 'NC' then
1043: if p_prior_pay_rate_det_code in ('0','7')
1044: then
1045:
1046: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1047: p_prior_grade_or_level,
1048: 'Minimum Basic Pay',p_prior_effective_date);
1049: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1050: p_prior_grade_or_level,

Line 1049: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',

1045:
1046: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1047: p_prior_grade_or_level,
1048: 'Minimum Basic Pay',p_prior_effective_date);
1049: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1050: p_prior_grade_or_level,
1051: 'Maximum Basic Pay',p_prior_effective_date);
1052: elsif p_prior_pay_rate_det_code in ('5','6') then
1053: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',

Line 1053: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',

1049: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1050: p_prior_grade_or_level,
1051: 'Maximum Basic Pay',p_prior_effective_date);
1052: elsif p_prior_pay_rate_det_code in ('5','6') then
1053: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1054: p_prior_grade_or_level,
1055: 'Minimum Basic Pay',p_prior_effective_date);
1056: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1057: p_prior_grade_or_level,

Line 1056: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',

1052: elsif p_prior_pay_rate_det_code in ('5','6') then
1053: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1054: p_prior_grade_or_level,
1055: 'Minimum Basic Pay',p_prior_effective_date);
1056: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1057: p_prior_grade_or_level,
1058: 'Maximum Basic Pay',p_prior_effective_date);
1059:
1060: end if;

Line 1089: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',

1085: if p_prior_pay_plan = 'NO' then
1086: if p_prior_pay_rate_det_code in ('0','7')
1087: then
1088:
1089: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1090: p_prior_grade_or_level,
1091: 'Minimum Basic Pay',p_prior_effective_date);
1092: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1093: p_prior_grade_or_level,

Line 1092: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',

1088:
1089: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1090: p_prior_grade_or_level,
1091: 'Minimum Basic Pay',p_prior_effective_date);
1092: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1093: p_prior_grade_or_level,
1094: 'Maximum Basic Pay',p_prior_effective_date);
1095: elsif p_prior_pay_rate_det_code in ('5','6') then
1096: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',

Line 1096: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',

1092: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1093: p_prior_grade_or_level,
1094: 'Maximum Basic Pay',p_prior_effective_date);
1095: elsif p_prior_pay_rate_det_code in ('5','6') then
1096: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1097: p_prior_grade_or_level,
1098: 'Minimum Basic Pay',p_prior_effective_date);
1099: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1100: p_prior_grade_or_level,

Line 1099: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',

1095: elsif p_prior_pay_rate_det_code in ('5','6') then
1096: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1097: p_prior_grade_or_level,
1098: 'Minimum Basic Pay',p_prior_effective_date);
1099: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1100: p_prior_grade_or_level,
1101: 'Maximum Basic Pay',p_prior_effective_date);
1102:
1103: end if;

Line 1131: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',

1127: if p_prior_pay_plan = 'NP' then
1128: if p_prior_pay_rate_det_code in ('0','7')
1129: then
1130:
1131: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
1132: p_prior_grade_or_level,
1133: 'Minimum Basic Pay',p_prior_effective_date);
1134: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
1135: p_prior_grade_or_level,

Line 1134: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',

1130:
1131: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
1132: p_prior_grade_or_level,
1133: 'Minimum Basic Pay',p_prior_effective_date);
1134: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
1135: p_prior_grade_or_level,
1136: 'Maximum Basic Pay',p_prior_effective_date);
1137: elsif p_prior_pay_rate_det_code in ('5','6') then
1138: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',

Line 1138: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',

1134: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
1135: p_prior_grade_or_level,
1136: 'Maximum Basic Pay',p_prior_effective_date);
1137: elsif p_prior_pay_rate_det_code in ('5','6') then
1138: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
1139: p_prior_grade_or_level,
1140: 'Minimum Basic Pay',p_prior_effective_date);
1141: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
1142: p_prior_grade_or_level,

Line 1141: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',

1137: elsif p_prior_pay_rate_det_code in ('5','6') then
1138: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
1139: p_prior_grade_or_level,
1140: 'Minimum Basic Pay',p_prior_effective_date);
1141: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
1142: p_prior_grade_or_level,
1143: 'Maximum Basic Pay',p_prior_effective_date);
1144:
1145: end if;

Line 1175: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',

1171: if p_prior_pay_plan = 'NR' then
1172: if p_prior_pay_rate_det_code in ('0','7')
1173: then
1174:
1175: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1176: p_prior_grade_or_level,
1177: 'Minimum Basic Pay',p_prior_effective_date);
1178: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1179: p_prior_grade_or_level,

Line 1178: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',

1174:
1175: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1176: p_prior_grade_or_level,
1177: 'Minimum Basic Pay',p_prior_effective_date);
1178: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1179: p_prior_grade_or_level,
1180: 'Maximum Basic Pay',p_prior_effective_date);
1181: elsif p_prior_pay_rate_det_code in ('5','6') then
1182: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',

Line 1182: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',

1178: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1179: p_prior_grade_or_level,
1180: 'Maximum Basic Pay',p_prior_effective_date);
1181: elsif p_prior_pay_rate_det_code in ('5','6') then
1182: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
1183: p_prior_grade_or_level,
1184: 'Minimum Basic Pay',p_prior_effective_date);
1185: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
1186: p_prior_grade_or_level,

Line 1185: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',

1181: elsif p_prior_pay_rate_det_code in ('5','6') then
1182: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
1183: p_prior_grade_or_level,
1184: 'Minimum Basic Pay',p_prior_effective_date);
1185: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
1186: p_prior_grade_or_level,
1187: 'Maximum Basic Pay',p_prior_effective_date);
1188:
1189: end if;

Line 1214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',

1210:
1211: if p_prior_pay_plan = 'GM' and
1212: p_prior_pay_rate_det_code in ('5', '6', 'M') then
1213:
1214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1215: p_prior_grade_or_level,
1216: 'Minimum Basic Pay',p_prior_effective_date);
1217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1218: p_prior_grade_or_level,

Line 1217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',

1213:
1214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1215: p_prior_grade_or_level,
1216: 'Minimum Basic Pay',p_prior_effective_date);
1217: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1218: p_prior_grade_or_level,
1219: 'Maximum Basic Pay',p_prior_effective_date);
1220:
1221: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 1245: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',

1241: if p_prior_pay_plan = 'AL' and
1242: p_prior_pay_rate_det_code <> 'C' then
1243:
1244: if p_prior_grade_or_level in ('01', '02') then
1245: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
1246: p_prior_grade_or_level,
1247: 'Minimum Basic Pay',
1248: p_prior_effective_date);
1249: else

Line 1250: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',

1246: p_prior_grade_or_level,
1247: 'Minimum Basic Pay',
1248: p_prior_effective_date);
1249: else
1250: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
1251: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
1252: 'Minimum Basic Pay',
1253: p_prior_effective_date);
1254: end if;

Line 1278: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 23',

1274: Basis for Edit: 5 U.S.C. 5372a*/
1275: if p_prior_pay_plan = 'CA' and
1276: p_prior_pay_rate_det_code <> 'C' then
1277:
1278: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 23',
1279: p_prior_grade_or_level,
1280: 'Minimum Basic Pay',p_prior_effective_date);
1281:
1282: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 1307: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

1303: IF p_effective_date >= to_date('2008/10/14','RRRR/MM/DD') then --Bug#8653515
1304: if p_prior_pay_plan in ('ST', 'SL') and
1305: p_prior_pay_rate_det_code NOT IN ('C','D') then
1306:
1307: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1308: p_prior_pay_plan ,
1309: 'Minimum Basic Pay',p_prior_effective_date);
1310:
1311: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

Line 1311: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

1307: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1308: p_prior_pay_plan ,
1309: 'Minimum Basic Pay',p_prior_effective_date);
1310:
1311: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1312: p_prior_pay_plan ,
1313: 'Maximum Basic Pay',p_prior_effective_date);
1314:
1315: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 1329: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

1325: ELSE
1326: if p_prior_pay_plan in ('ST', 'SL') and
1327: p_prior_pay_rate_det_code <> 'C' then
1328:
1329: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1330: p_prior_pay_plan ,
1331: 'Minimum Basic Pay',p_prior_effective_date);
1332:
1333: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

Line 1333: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

1329: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1330: p_prior_pay_plan ,
1331: 'Minimum Basic Pay',p_prior_effective_date);
1332:
1333: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1334: p_prior_pay_plan ,
1335: 'Maximum Basic Pay',p_prior_effective_date);
1336:
1337: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 1363: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',

1359: -- added extra if for bug 726125
1360: if p_prior_pay_plan = 'ND' and
1361: p_prior_pay_rate_det_code in ('0','5','6','7') then
1362: if p_prior_pay_rate_det_code in ('0','7') then
1363: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1364: p_prior_grade_or_level ,
1365: 'Minimum Basic Pay',
1366: p_prior_effective_date);
1367: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',

Line 1367: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',

1363: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1364: p_prior_grade_or_level ,
1365: 'Minimum Basic Pay',
1366: p_prior_effective_date);
1367: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1368: p_prior_grade_or_level ,
1369: 'Maximum Basic Pay',
1370: p_prior_effective_date);
1371: elsif p_prior_pay_rate_det_code in ('5','6') then

Line 1372: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',

1368: p_prior_grade_or_level ,
1369: 'Maximum Basic Pay',
1370: p_prior_effective_date);
1371: elsif p_prior_pay_rate_det_code in ('5','6') then
1372: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1373: p_prior_grade_or_level ,
1374: 'Minimum Basic Pay',
1375: p_prior_effective_date);
1376: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',

Line 1376: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',

1372: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1373: p_prior_grade_or_level ,
1374: 'Minimum Basic Pay',
1375: p_prior_effective_date);
1376: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1377: p_prior_grade_or_level ,
1378: 'Maximum Basic Pay',
1379: p_prior_effective_date);
1380: end if;

Line 1408: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',

1404: -- added extra if for bug 726125
1405: if p_prior_pay_plan = 'NG' and
1406: p_prior_pay_rate_det_code in ('0','5','6','7') then
1407: if p_prior_pay_rate_det_code in ('0','7') then
1408: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1409: p_prior_grade_or_level ,
1410: 'Minimum Basic Pay',
1411: p_prior_effective_date);
1412: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',

Line 1412: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',

1408: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1409: p_prior_grade_or_level ,
1410: 'Minimum Basic Pay',
1411: p_prior_effective_date);
1412: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1413: p_prior_grade_or_level ,
1414: 'Maximum Basic Pay',
1415: p_prior_effective_date);
1416: elsif p_prior_pay_rate_det_code in ('5','6') then

Line 1417: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',

1413: p_prior_grade_or_level ,
1414: 'Maximum Basic Pay',
1415: p_prior_effective_date);
1416: elsif p_prior_pay_rate_det_code in ('5','6') then
1417: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1418: p_prior_grade_or_level ,
1419: 'Minimum Basic Pay',
1420: p_prior_effective_date);
1421: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',

Line 1421: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',

1417: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1418: p_prior_grade_or_level ,
1419: 'Minimum Basic Pay',
1420: p_prior_effective_date);
1421: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1422: p_prior_grade_or_level,
1423: 'Maximum Basic Pay',
1424: p_prior_effective_date);
1425: end if;

Line 1452: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',

1448:
1449: if p_prior_pay_plan = 'NT' and
1450: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
1451: if p_prior_pay_rate_det_code in ('0','7') then
1452: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1453: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1455: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1456: elsif p_prior_pay_rate_det_code in ('5','6') then

Line 1454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',

1450: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
1451: if p_prior_pay_rate_det_code in ('0','7') then
1452: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1453: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1455: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1456: elsif p_prior_pay_rate_det_code in ('5','6') then
1457: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1458: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);

Line 1457: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',

1453: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1455: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1456: elsif p_prior_pay_rate_det_code in ('5','6') then
1457: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1458: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1459: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1460: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1461: end if;

Line 1459: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',

1455: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1456: elsif p_prior_pay_rate_det_code in ('5','6') then
1457: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1458: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1459: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1460: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1461: end if;
1462:
1463: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

Line 1486: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',

1482: basic pay.
1483: if p_prior_pay_plan = 'TP' and
1484: p_prior_pay_basis = 'SY' then
1485:
1486: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
1487: p_prior_pay_plan ,
1488: 'Minimum Basic Pay',
1489: p_prior_effective_date);
1490: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',

Line 1490: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',

1486: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
1487: p_prior_pay_plan ,
1488: 'Minimum Basic Pay',
1489: p_prior_effective_date);
1490: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
1491: p_prior_pay_plan ,
1492: 'Maximum Basic Pay',
1493: p_prior_effective_date);
1494: if max_basic_pay IS NOT NULL and

Line 1517: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

1513: if p_prior_pay_plan = 'CG' and
1514: p_prior_pay_rate_det_code = '0' and
1515: p_prior_grade_or_level = 'SL' then
1516:
1517: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1518: p_prior_pay_plan ,
1519: 'Minimum Basic Pay',
1520: p_prior_effective_date);
1521:

Line 1522: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

1518: p_prior_pay_plan ,
1519: 'Minimum Basic Pay',
1520: p_prior_effective_date);
1521:
1522: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1523: p_prior_pay_plan ,
1524: 'Maximum Basic Pay',
1525: p_prior_effective_date);
1526: if max_basic_pay IS NOT NULL and min_basic_pay is not null and

Line 1548: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 36',

1544: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1545: if p_prior_pay_plan = 'IJ' and
1546: p_prior_pay_rate_det_code in ('0','7') then
1547:
1548: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 36',
1549: p_prior_step_or_rate ,
1550: 'Maximum Basic Pay',
1551: p_prior_effective_date);
1552: if max_basic_pay IS NOT NULL and

Line 1577: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',

1573: if p_prior_pay_plan = 'CG' and
1574: p_prior_grade_or_level between '01' and '15' and
1575: p_prior_pay_rate_det_code in ('2','3','4','J','K','R','Y') then
1576:
1577: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1578: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1579: 'Minimum Basic Pay',
1580: p_prior_effective_date);
1581: if min_basic_pay IS NOT NULL and

Line 1603: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

1599: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1600: if p_prior_pay_plan = 'GH' and
1601: p_prior_pay_rate_det_code in ('0','7') then
1602:
1603: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1604: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1605: 'Minimum Basic Pay',
1606: p_prior_effective_date);
1607: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

Line 1607: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

1603: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1604: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1605: 'Minimum Basic Pay',
1606: p_prior_effective_date);
1607: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1608: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1609: 'Maximum Basic Pay',
1610: p_prior_effective_date);
1611:

Line 1683: l_table5_value:= GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',

1679: open c1;
1680: fetch c1 into l_lpa_effective_start_date, l_lpa_effective_end_date,
1681: l_lpa_pct, l_leo_pct;
1682: close c1;
1683: l_table5_value:= GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',
1684: '04' ,
1685: 'Maximum Basic Pay',p_effective_date);
1686: --
1687: -- 27-jul-98

Line 2620: l_table5_value:= GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',

2616: open c1;
2617: fetch c1 into l_lpa_effective_start_date, l_lpa_effective_end_date,
2618: l_lpa_pct, l_leo_pct;
2619: close c1;
2620: l_table5_value:= GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',
2621: '04' ,
2622: 'Maximum Basic Pay',p_effective_date);
2623: --
2624: -- 27-jul-98

Line 3051: end GHR_CPDF_CHECK7;

3047: end if;
3048: END IF;
3049: hr_utility.set_location('Leaving CPDF 7 ',1);
3050: end chk_prior_locality_adj;
3051: end GHR_CPDF_CHECK7;