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.7.12000000.4 2007/04/20 09:25:51 utokachi noship $ */
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 186: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

595: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
596: -------------------------------------------------------------------------------
597: IF p_prior_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
598: if p_prior_pay_plan = 'KA' then
599: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
600: p_prior_pay_plan ,
601: 'Minimum Basic Pay',
602: p_prior_effective_date);
603: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

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

599: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
600: p_prior_pay_plan ,
601: 'Minimum Basic Pay',
602: p_prior_effective_date);
603: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
604: p_prior_pay_plan ,
605: 'Maximum Basic Pay',
606: p_prior_effective_date);
607: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

626: -- Madhuri 19-MAY-2004 End dated the Edit as of 10-JAN-04
627: --
628: IF p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') then
629: if p_prior_pay_plan in ('FB', 'FJ', 'FX') then
630: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
631: '01',
632: 'Maximum Basic Pay',
633: p_prior_effective_date);
634: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',

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

630: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
631: '01',
632: 'Maximum Basic Pay',
633: p_prior_effective_date);
634: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
635: '06',
636: 'Maximum Basic Pay',
637: p_prior_effective_date);
638:

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

654:
655: Default: Insert asterisks in prior pay basis and prior
656: basic pay.*/
657: if p_prior_pay_plan = 'FT' then
658: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
659: p_prior_pay_plan ,
660: 'Minimum Basic Pay',
661: p_prior_effective_date);
662: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

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

658: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
659: p_prior_pay_plan ,
660: 'Minimum Basic Pay',
661: p_prior_effective_date);
662: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
663: p_prior_pay_plan ,
664: 'Maximum Basic Pay',
665: p_prior_effective_date);
666: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

686: -- 18/10/2004 Madhuri From the start of the edit Deleting the edit
687: -----------------------------------------------------------------------------------------------------------
688:
689: /*if p_prior_pay_plan in ('FL', 'FS', 'FW') then
690: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
691: 'WG'||'-'||p_prior_grade_or_level,
692: 'Minimum Basic Pay',p_prior_effective_date);
693: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
694: 'WS'||'-'||p_prior_grade_or_level,

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

689: /*if p_prior_pay_plan in ('FL', 'FS', 'FW') then
690: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
691: 'WG'||'-'||p_prior_grade_or_level,
692: 'Minimum Basic Pay',p_prior_effective_date);
693: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
694: 'WS'||'-'||p_prior_grade_or_level,
695: 'Maximum Basic Pay',p_prior_effective_date);
696:
697: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

717: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
718: if p_prior_pay_plan = 'FM' and
719: p_prior_pay_rate_det_code in ('0','7') then
720:
721: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
722: p_prior_grade_or_level ,
723: 'Minimum Basic Pay',p_prior_effective_date);
724: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
725: p_prior_grade_or_level ,

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

720:
721: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
722: p_prior_grade_or_level ,
723: 'Minimum Basic Pay',p_prior_effective_date);
724: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
725: p_prior_grade_or_level ,
726: 'Maximum Basic Pay',p_prior_effective_date);
727: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
728: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

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

736: else
737: if p_prior_pay_plan = 'FM' and
738: p_prior_pay_rate_det_code in ('0','7') then
739:
740: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
741: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
742: 'Minimum Basic Pay',p_prior_effective_date);
743: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
744: p_prior_grade_or_level || '-' || p_prior_step_or_rate,

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

739:
740: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
741: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
742: 'Minimum Basic Pay',p_prior_effective_date);
743: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
744: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
745: 'Maximum Basic Pay',p_prior_effective_date);
746: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
747: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

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

765: basic pay.
766: if p_prior_pay_plan = 'DR' and
767: p_prior_pay_rate_det_code in ('0','7') then
768:
769: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
770: p_prior_grade_or_level ,
771: 'Minimum Basic Pay',p_prior_effective_date);
772: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
773: p_prior_grade_or_level ,

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

768:
769: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
770: p_prior_grade_or_level ,
771: 'Minimum Basic Pay',p_prior_effective_date);
772: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
773: p_prior_grade_or_level ,
774: 'Maximum Basic Pay',p_prior_effective_date);
775:
776: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

795: basic pay.
796: if p_prior_pay_plan = 'DR' and
797: p_prior_pay_rate_det_code in ('5','6') then
798:
799: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
800: p_prior_grade_or_level ,
801: 'Minimum Basic Pay',p_prior_effective_date);
802: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
803: p_prior_grade_or_level ,

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

798:
799: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
800: p_prior_grade_or_level ,
801: 'Minimum Basic Pay',p_prior_effective_date);
802: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
803: p_prior_grade_or_level ,
804: 'Maximum Basic Pay',p_prior_effective_date);
805: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
806: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

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

819:
820: Default: Insert asterisks in prior pay basis and prior
821: basic pay.*/
822: if p_prior_pay_plan = 'NY' then
823: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
824: p_prior_grade_or_level ,
825: 'Minimum Basic Pay',p_prior_effective_date);
826: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
827: p_prior_grade_or_level ,

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

822: if p_prior_pay_plan = 'NY' then
823: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
824: p_prior_grade_or_level ,
825: 'Minimum Basic Pay',p_prior_effective_date);
826: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
827: p_prior_grade_or_level ,
828: 'Maximum Basic Pay',p_prior_effective_date);
829: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
830: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

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

843: Default: Insert asterisks in prior pay basis and prior
844: basic pay.*/
845: if p_prior_pay_plan = 'NX' then
846:
847: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
848: p_prior_grade_or_level ,
849: 'Minimum Basic Pay',p_prior_effective_date);
850: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
851: p_prior_grade_or_level ,

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

846:
847: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
848: p_prior_grade_or_level ,
849: 'Minimum Basic Pay',p_prior_effective_date);
850: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
851: p_prior_grade_or_level ,
852: 'Maximum Basic Pay',p_prior_effective_date);
853:
854: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

876:
877: if p_prior_pay_plan = 'FC' and
878: p_prior_pay_rate_det_code <> 'C' then
879:
880: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
881: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
882: 'Minimum Basic Pay',p_prior_effective_date);
883:
884: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

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

880: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
881: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
882: 'Minimum Basic Pay',p_prior_effective_date);
883:
884: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
885: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
886: 'Maximum Basic Pay',p_prior_effective_date);
887:
888: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

903: basic pay.*/
904: if p_prior_pay_plan in ('AF','FO','FP') and
905: p_prior_pay_rate_det_code <> 'C' then
906:
907: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
908: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
909: 'Minimum Basic Pay',p_prior_effective_date);
910: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
911: p_prior_grade_or_level || '-' || p_prior_step_or_rate,

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

906:
907: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
908: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
909: 'Minimum Basic Pay',p_prior_effective_date);
910: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
911: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
912: 'Maximum Basic Pay',p_prior_effective_date);
913: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
914: (not(to_number(p_prior_basic_pay) between min_basic_pay and max_basic_pay )

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

942: p_agency_subelement = 'ST' and
943: p_prior_pay_rate_det_code = '0' and
944: p_prior_grade_or_level in ('13','14') then
945:
946: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',
947: p_prior_step_or_rate,
948: 'Maximum Basic Pay',
949: p_prior_effective_date);
950:

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

969: /* Commenting the edit as per the Bug 3147737.
970: if p_prior_pay_plan = 'GS' and
971: p_prior_pay_rate_det_code in ('5','6','M') then
972:
973: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
974: p_prior_grade_or_level,
975: 'Maximum Basic Pay',
976: p_prior_effective_date);
977:

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

1001: if p_prior_pay_plan = 'NC' then
1002: if p_prior_pay_rate_det_code in ('0','7')
1003: then
1004:
1005: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1006: p_prior_grade_or_level,
1007: 'Minimum Basic Pay',p_prior_effective_date);
1008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1009: p_prior_grade_or_level,

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

1004:
1005: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1006: p_prior_grade_or_level,
1007: 'Minimum Basic Pay',p_prior_effective_date);
1008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1009: p_prior_grade_or_level,
1010: 'Maximum Basic Pay',p_prior_effective_date);
1011: elsif p_prior_pay_rate_det_code in ('5','6') then
1012: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',

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

1008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1009: p_prior_grade_or_level,
1010: 'Maximum Basic Pay',p_prior_effective_date);
1011: elsif p_prior_pay_rate_det_code in ('5','6') then
1012: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1013: p_prior_grade_or_level,
1014: 'Minimum Basic Pay',p_prior_effective_date);
1015: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1016: p_prior_grade_or_level,

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

1011: elsif p_prior_pay_rate_det_code in ('5','6') then
1012: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1013: p_prior_grade_or_level,
1014: 'Minimum Basic Pay',p_prior_effective_date);
1015: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1016: p_prior_grade_or_level,
1017: 'Maximum Basic Pay',p_prior_effective_date);
1018:
1019: end if;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1130: if p_prior_pay_plan = 'NR' then
1131: if p_prior_pay_rate_det_code in ('0','7')
1132: then
1133:
1134: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1135: p_prior_grade_or_level,
1136: 'Minimum Basic Pay',p_prior_effective_date);
1137: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
1138: p_prior_grade_or_level,

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

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

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

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

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

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

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

1169:
1170: if p_prior_pay_plan = 'GM' and
1171: p_prior_pay_rate_det_code in ('5', '6', 'M') then
1172:
1173: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1174: p_prior_grade_or_level,
1175: 'Minimum Basic Pay',p_prior_effective_date);
1176: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1177: p_prior_grade_or_level,

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

1172:
1173: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1174: p_prior_grade_or_level,
1175: 'Minimum Basic Pay',p_prior_effective_date);
1176: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1177: p_prior_grade_or_level,
1178: 'Maximum Basic Pay',p_prior_effective_date);
1179:
1180: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1200: if p_prior_pay_plan = 'AL' and
1201: p_prior_pay_rate_det_code <> 'C' then
1202:
1203: if p_prior_grade_or_level in ('01', '02') then
1204: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
1205: p_prior_grade_or_level,
1206: 'Minimum Basic Pay',
1207: p_prior_effective_date);
1208: else

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

1205: p_prior_grade_or_level,
1206: 'Minimum Basic Pay',
1207: p_prior_effective_date);
1208: else
1209: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
1210: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
1211: 'Minimum Basic Pay',
1212: p_prior_effective_date);
1213: end if;

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

1233: Basis for Edit: 5 U.S.C. 5372a*/
1234: if p_prior_pay_plan = 'CA' and
1235: p_prior_pay_rate_det_code <> 'C' then
1236:
1237: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 23',
1238: p_prior_grade_or_level,
1239: 'Minimum Basic Pay',p_prior_effective_date);
1240:
1241: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1259:
1260: if p_prior_pay_plan in ('ST', 'SL') and
1261: p_prior_pay_rate_det_code <> 'C' then
1262:
1263: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1264: p_prior_pay_plan ,
1265: 'Minimum Basic Pay',p_prior_effective_date);
1266:
1267: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

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

1263: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1264: p_prior_pay_plan ,
1265: 'Minimum Basic Pay',p_prior_effective_date);
1266:
1267: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1268: p_prior_pay_plan ,
1269: 'Maximum Basic Pay',p_prior_effective_date);
1270:
1271: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1291: -- added extra if for bug 726125
1292: if p_prior_pay_plan = 'ND' and
1293: p_prior_pay_rate_det_code in ('0','5','6','7') then
1294: if p_prior_pay_rate_det_code in ('0','7') then
1295: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1296: p_prior_grade_or_level ,
1297: 'Minimum Basic Pay',
1298: p_prior_effective_date);
1299: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',

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

1295: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1296: p_prior_grade_or_level ,
1297: 'Minimum Basic Pay',
1298: p_prior_effective_date);
1299: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1300: p_prior_grade_or_level ,
1301: 'Maximum Basic Pay',
1302: p_prior_effective_date);
1303: elsif p_prior_pay_rate_det_code in ('5','6') then

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

1300: p_prior_grade_or_level ,
1301: 'Maximum Basic Pay',
1302: p_prior_effective_date);
1303: elsif p_prior_pay_rate_det_code in ('5','6') then
1304: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1305: p_prior_grade_or_level ,
1306: 'Minimum Basic Pay',
1307: p_prior_effective_date);
1308: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',

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

1304: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1305: p_prior_grade_or_level ,
1306: 'Minimum Basic Pay',
1307: p_prior_effective_date);
1308: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1309: p_prior_grade_or_level ,
1310: 'Maximum Basic Pay',
1311: p_prior_effective_date);
1312: end if;

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

1336: -- added extra if for bug 726125
1337: if p_prior_pay_plan = 'NG' and
1338: p_prior_pay_rate_det_code in ('0','5','6','7') then
1339: if p_prior_pay_rate_det_code in ('0','7') then
1340: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1341: p_prior_grade_or_level ,
1342: 'Minimum Basic Pay',
1343: p_prior_effective_date);
1344: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',

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

1340: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1341: p_prior_grade_or_level ,
1342: 'Minimum Basic Pay',
1343: p_prior_effective_date);
1344: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1345: p_prior_grade_or_level ,
1346: 'Maximum Basic Pay',
1347: p_prior_effective_date);
1348: elsif p_prior_pay_rate_det_code in ('5','6') then

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

1345: p_prior_grade_or_level ,
1346: 'Maximum Basic Pay',
1347: p_prior_effective_date);
1348: elsif p_prior_pay_rate_det_code in ('5','6') then
1349: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1350: p_prior_grade_or_level ,
1351: 'Minimum Basic Pay',
1352: p_prior_effective_date);
1353: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',

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

1349: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1350: p_prior_grade_or_level ,
1351: 'Minimum Basic Pay',
1352: p_prior_effective_date);
1353: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1354: p_prior_grade_or_level,
1355: 'Maximum Basic Pay',
1356: p_prior_effective_date);
1357: end if;

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

1380:
1381: if p_prior_pay_plan = 'NT' and
1382: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
1383: if p_prior_pay_rate_det_code in ('0','7') then
1384: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1385: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1386: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1387: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1388: elsif p_prior_pay_rate_det_code in ('5','6') then

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

1382: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
1383: if p_prior_pay_rate_det_code in ('0','7') then
1384: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1385: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1386: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1387: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1388: elsif p_prior_pay_rate_det_code in ('5','6') then
1389: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1390: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);

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

1385: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1386: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1387: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1388: elsif p_prior_pay_rate_det_code in ('5','6') then
1389: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1390: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1391: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1392: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1393: end if;

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

1387: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1388: elsif p_prior_pay_rate_det_code in ('5','6') then
1389: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1390: p_prior_grade_or_level ,'Minimum Basic Pay',p_prior_effective_date);
1391: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1392: p_prior_grade_or_level ,'Maximum Basic Pay',p_prior_effective_date);
1393: end if;
1394:
1395: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

1414: basic pay.
1415: if p_prior_pay_plan = 'TP' and
1416: p_prior_pay_basis = 'SY' then
1417:
1418: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
1419: p_prior_pay_plan ,
1420: 'Minimum Basic Pay',
1421: p_prior_effective_date);
1422: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',

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

1418: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
1419: p_prior_pay_plan ,
1420: 'Minimum Basic Pay',
1421: p_prior_effective_date);
1422: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
1423: p_prior_pay_plan ,
1424: 'Maximum Basic Pay',
1425: p_prior_effective_date);
1426: if max_basic_pay IS NOT NULL and

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

1445: if p_prior_pay_plan = 'CG' and
1446: p_prior_pay_rate_det_code = '0' and
1447: p_prior_grade_or_level = 'SL' then
1448:
1449: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1450: p_prior_pay_plan ,
1451: 'Minimum Basic Pay',
1452: p_prior_effective_date);
1453:

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

1450: p_prior_pay_plan ,
1451: 'Minimum Basic Pay',
1452: p_prior_effective_date);
1453:
1454: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1455: p_prior_pay_plan ,
1456: 'Maximum Basic Pay',
1457: p_prior_effective_date);
1458: if max_basic_pay IS NOT NULL and min_basic_pay is not null and

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

1474: basic pay.*/
1475: if p_prior_pay_plan = 'IJ' and
1476: p_prior_pay_rate_det_code in ('0','7') then
1477:
1478: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 36',
1479: p_prior_step_or_rate ,
1480: 'Maximum Basic Pay',
1481: p_prior_effective_date);
1482: if max_basic_pay IS NOT NULL and

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

1501: if p_prior_pay_plan = 'CG' and
1502: p_prior_grade_or_level between '01' and '15' and
1503: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
1504:
1505: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1506: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1507: 'Minimum Basic Pay',
1508: p_prior_effective_date);
1509: if min_basic_pay IS NOT NULL and

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

1525: basic pay.*/
1526: if p_prior_pay_plan = 'GH' and
1527: p_prior_pay_rate_det_code in ('0','7') then
1528:
1529: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1530: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1531: 'Minimum Basic Pay',
1532: p_prior_effective_date);
1533: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1529: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1530: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1531: 'Minimum Basic Pay',
1532: p_prior_effective_date);
1533: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1534: p_prior_grade_or_level||'-'||p_prior_step_or_rate ,
1535: 'Maximum Basic Pay',
1536: p_prior_effective_date);
1537:

Line 2796: end GHR_CPDF_CHECK7;

2792: end if;
2793:
2794: hr_utility.set_location('Leaving CPDF 7 ',1);
2795: end chk_prior_locality_adj;
2796: end GHR_CPDF_CHECK7;