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_CHECK8 dependencies on GHR_CPDF_CHECK

Line 1: package body GHR_CPDF_CHECK8 as

1: package body GHR_CPDF_CHECK8 as
2: /* $Header: ghcpdf08.pkb 120.7.12010000.7 2010/01/08 06:51:36 utokachi ship $ */
3:
4: min_basic_pay number(10,2);
5: max_basic_pay number(10,2);

Line 127: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',

123: then basic pay must be within the range on Table 43 */
124: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
125: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
126: if ( p_to_pay_plan = 'JA' ) then
127: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',
128: p_to_pay_plan,'Minimum Basic Pay', p_effective_date);
129: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',
130: p_to_pay_plan,'Maximum Basic Pay',p_effective_date);
131: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )

Line 129: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',

125: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
126: if ( p_to_pay_plan = 'JA' ) then
127: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',
128: p_to_pay_plan,'Minimum Basic Pay', p_effective_date);
129: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 43',
130: p_to_pay_plan,'Maximum Basic Pay',p_effective_date);
131: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
132: then
133: GHR_GHRWS52L.CPDF_Parameter_Check;

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

197: Default: Insert asterisks in pay basis and basic pay. */
198:
199: IF p_to_pay_plan = 'EX' and
200: p_rate_determinant_code = '0' THEN
201: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',
202: p_to_grade_or_level ,
203: 'Maximum Basic Pay',
204: p_effective_date);
205: IF NVL(to_number(p_to_basic_pay), 0) <> max_basic_pay THEN

Line 222: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',

218: then basic pay must be within the range for the grade on Table 52 */
219: if p_effective_date >= to_date('2000/05/01','yyyy/mm/dd') and
220: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
221: if ( p_to_pay_plan = 'VE' and p_rate_determinant_code = '0' ) THEN
222: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
223: p_to_grade_or_level,'Minimum Basic Pay',p_effective_date);
224: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
225: p_to_grade_or_level,'Maximum Basic Pay',p_effective_date);
226: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )

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

220: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
221: if ( p_to_pay_plan = 'VE' and p_rate_determinant_code = '0' ) THEN
222: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
223: p_to_grade_or_level,'Minimum Basic Pay',p_effective_date);
224: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
225: p_to_grade_or_level,'Maximum Basic Pay',p_effective_date);
226: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )
227: then
228: GHR_GHRWS52L.CPDF_Parameter_Check;

Line 243: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',

239: And pay rate determinant is 0,
240: then basic pay must be within the range for the grade on Table 52 */
241: /* if p_effective_date >= to_date('2000/05/01','yyyy/mm/dd') then
242: if ( p_to_pay_plan = 'VE' and p_rate_determinant_code = '0' ) THEN
243: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
244: p_to_grade_or_level,
245: 'Minimum Basic Pay',
246: p_effective_date);
247: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',

Line 247: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',

243: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
244: p_to_grade_or_level,
245: 'Minimum Basic Pay',
246: p_effective_date);
247: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 52',
248: p_to_grade_or_level,
249: 'Maximum Basic Pay',
250: p_effective_date);
251: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )

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

283: ELSIF ( p_effective_date >= to_date('2004/01/11', 'yyyy/mm/dd') and
284: p_to_pay_plan IN ('ES', 'FE') and p_rate_determinant_code = '0' )
285: THEN
286: -- 650.37.3
287: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',
288: p_to_pay_plan,
289: 'Minimum Basic Pay',
290: p_effective_date);
291: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',

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

287: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',
288: p_to_pay_plan,
289: 'Minimum Basic Pay',
290: p_effective_date);
291: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 55',
292: p_to_pay_plan,
293: 'Maximum Basic Pay',
294: p_effective_date);
295: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )

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

421: then basic pay must be within the range for the grade on Table 14 */
422: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
423: if ( p_to_pay_plan = 'VN' and p_rate_determinant_code = '0'
424: and p_occupation_code in ('0601','0603') ) then
425: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
426: p_to_pay_plan,
427: 'Minimum Basic Pay',
428: p_effective_date);
429: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',

Line 429: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',

425: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
426: p_to_pay_plan,
427: 'Minimum Basic Pay',
428: p_effective_date);
429: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
430: p_to_pay_plan,
431: 'Maximum Basic Pay',
432: p_effective_date);
433: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )

Line 454: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',

450: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
451: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
452: if ( p_to_pay_plan = 'VN' and p_rate_determinant_code = '0'
453: and p_occupation_code in ('0605','0610') ) then
454: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',
455: p_to_pay_plan,
456: 'Minimum Basic Pay',
457: p_effective_date);
458: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',

Line 458: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',

454: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',
455: p_to_pay_plan,
456: 'Minimum Basic Pay',
457: p_effective_date);
458: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',
459: p_to_pay_plan,
460: 'Maximum Basic Pay',
461: p_effective_date);
462: if not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay )

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

723: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
724: p_to_pay_plan = 'NH' and
725: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
726: if p_rate_determinant_code in ('0','7') then
727: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
728: p_to_grade_or_level ,
729: 'Minimum Basic Pay',p_effective_date);
730: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
731: p_to_grade_or_level ,

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

726: if p_rate_determinant_code in ('0','7') then
727: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
728: p_to_grade_or_level ,
729: 'Minimum Basic Pay',p_effective_date);
730: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
731: p_to_grade_or_level ,
732: 'Maximum Basic Pay',p_effective_date);
733: elsif p_rate_determinant_code in ('5','6') then
734: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',

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

730: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
731: p_to_grade_or_level ,
732: 'Maximum Basic Pay',p_effective_date);
733: elsif p_rate_determinant_code in ('5','6') then
734: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
735: p_to_grade_or_level ,
736: 'Minimum Basic Pay',p_effective_date);
737: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
738: p_to_grade_or_level ,

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

733: elsif p_rate_determinant_code in ('5','6') then
734: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
735: p_to_grade_or_level ,
736: 'Minimum Basic Pay',p_effective_date);
737: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 38',
738: p_to_grade_or_level ,
739: 'Maximum Basic Pay',p_effective_date);
740: end if;
741: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

757: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
758: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
759: if p_to_pay_plan = 'NY' then
760:
761: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
762: p_to_grade_or_level ,
763: 'Minimum Basic Pay',p_effective_date);
764:
765: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',

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

761: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
762: p_to_grade_or_level ,
763: 'Minimum Basic Pay',p_effective_date);
764:
765: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
766: p_to_grade_or_level ,
767: 'Maximum Basic Pay',p_effective_date);
768:
769: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

785: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
786: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
787: if p_to_pay_plan = 'NX' then
788:
789: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
790: p_to_grade_or_level ,
791: 'Minimum Basic Pay',p_effective_date);
792:
793: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',

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

789: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
790: p_to_grade_or_level ,
791: 'Minimum Basic Pay',p_effective_date);
792:
793: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
794: p_to_grade_or_level ,
795: 'Maximum Basic Pay',p_effective_date);
796:
797: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

815: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
816: p_to_pay_plan = 'NJ' and
817: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
818: if p_rate_determinant_code in ('0','7') then
819: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
820: p_to_grade_or_level ,
821: 'Minimum Basic Pay',p_effective_date);
822: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
823: p_to_grade_or_level ,

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

818: if p_rate_determinant_code in ('0','7') then
819: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
820: p_to_grade_or_level ,
821: 'Minimum Basic Pay',p_effective_date);
822: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
823: p_to_grade_or_level ,
824: 'Maximum Basic Pay',p_effective_date);
825: elsif p_rate_determinant_code in ('5','6') then
826: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',

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

822: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
823: p_to_grade_or_level ,
824: 'Maximum Basic Pay',p_effective_date);
825: elsif p_rate_determinant_code in ('5','6') then
826: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
827: p_to_grade_or_level ,
828: 'Minimum Basic Pay',p_effective_date);
829: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
830: p_to_grade_or_level ,

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

825: elsif p_rate_determinant_code in ('5','6') then
826: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
827: p_to_grade_or_level ,
828: 'Minimum Basic Pay',p_effective_date);
829: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
830: p_to_grade_or_level ,
831: 'Maximum Basic Pay',p_effective_date);
832: end if;
833: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

851: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
852: p_to_pay_plan = 'NK' and
853: p_rate_determinant_code in ('0','5','6','7') then
854: if p_rate_determinant_code in ('0','7') then
855: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
856: p_to_grade_or_level ,
857: 'Minimum Basic Pay',p_effective_date);
858: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
859: p_to_grade_or_level ,

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

854: if p_rate_determinant_code in ('0','7') then
855: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
856: p_to_grade_or_level ,
857: 'Minimum Basic Pay',p_effective_date);
858: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
859: p_to_grade_or_level ,
860: 'Maximum Basic Pay',p_effective_date);
861: elsif p_rate_determinant_code in ('5','6') then
862: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',

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

858: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
859: p_to_grade_or_level ,
860: 'Maximum Basic Pay',p_effective_date);
861: elsif p_rate_determinant_code in ('5','6') then
862: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
863: p_to_grade_or_level ,
864: 'Minimum Basic Pay',p_effective_date);
865: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
866: p_to_grade_or_level ,

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

861: elsif p_rate_determinant_code in ('5','6') then
862: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
863: p_to_grade_or_level ,
864: 'Minimum Basic Pay',p_effective_date);
865: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
866: p_to_grade_or_level ,
867: 'Maximum Basic Pay',p_effective_date);
868: end if;
869: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

892:
893: if p_to_pay_plan = 'GS' and
894: p_rate_determinant_code in ('2','3','4','J','K','R','Y') then
895:
896: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
897: p_to_grade_or_level || '-' || p_to_step_or_rate,
898: 'Minimum Basic Pay',p_effective_date);
899:
900: if min_basic_pay IS NOT NULL and

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

919: --
920: if p_rate_determinant_code in ('U','V') and
921: p_to_pay_plan in ('GG','GH','GS','GM') then
922:
923: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
924: p_retained_grade || '-' || p_retained_step,
925: 'Minimum Basic Pay',p_effective_date);
926:
927: if min_basic_pay IS NOT NULL and

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

944: Default: Insert asterisks in pay basis and basic pay.
945: if p_to_pay_plan = 'GM'
946: and p_rate_determinant_code in ('0', '7') then
947:
948: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
949: p_to_grade_or_level || '-' || p_to_step_or_rate,
950: 'Minimum Basic Pay',p_effective_date);
951:
952: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

948: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
949: p_to_grade_or_level || '-' || p_to_step_or_rate,
950: 'Minimum Basic Pay',p_effective_date);
951:
952: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
953: p_to_grade_or_level || '-' || p_to_step_or_rate,
954: 'Maximum Basic Pay',p_effective_date);
955:
956: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

972: */
973: if p_to_pay_plan = 'GM'
974: and p_rate_determinant_code in ('0', '7') then
975:
976: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
977: p_to_grade_or_level ,
978: 'Minimum Basic Pay',p_effective_date);
979:
980: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

976: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
977: p_to_grade_or_level ,
978: 'Minimum Basic Pay',p_effective_date);
979:
980: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
981: p_to_grade_or_level ,
982: 'Maximum Basic Pay',p_effective_date);
983:
984: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

999: Default: Insert asterisks in pay basis and basic pay.*/
1000: /*if p_to_pay_plan = 'GM'
1001: and p_rate_determinant_code in ('5', '6', 'M') then
1002:
1003: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1004: p_to_grade_or_level,
1005: 'Minimum Basic Pay',p_effective_date);
1006: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1007: p_to_grade_or_level,

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

1002:
1003: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1004: p_to_grade_or_level,
1005: 'Minimum Basic Pay',p_effective_date);
1006: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1007: p_to_grade_or_level,
1008: 'Maximum Basic Pay',p_effective_date);
1009:
1010: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

Line 1032: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(

1028: if (
1029: p_to_pay_plan = 'GL' and
1030: (p_rate_determinant_code = '0' or p_rate_determinant_code = '7')
1031: ) then
1032: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
1033: '0491 Oracle Federal Special Rate Pay Table (GS) No. 0491',
1034: 'GL' || '-' || p_to_grade_or_level,
1035: p_to_step_or_rate,
1036: p_effective_date);

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

1060: and p_rate_determinant_code in ('A','B')
1061: and p_retained_grade >= p_to_grade_or_level
1062: and p_retained_pay_plan in ('GH','GM') then
1063:
1064: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1065: p_retained_grade,
1066: 'Minimum Basic Pay',
1067: p_effective_date);
1068: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1064: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1065: p_retained_grade,
1066: 'Minimum Basic Pay',
1067: p_effective_date);
1068: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1069: p_retained_grade,
1070: 'Maximum Basic Pay',
1071: p_effective_date);
1072:

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

1085: and p_rate_determinant_code in ('A','B')
1086: and p_retained_grade >= p_to_grade_or_level
1087: and p_retained_pay_plan in ('GH','GM') then
1088:
1089: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1090: p_retained_grade|| '-' || p_retained_step,
1091: 'Minimum Basic Pay',
1092: p_effective_date);
1093: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1089: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1090: p_retained_grade|| '-' || p_retained_step,
1091: 'Minimum Basic Pay',
1092: p_effective_date);
1093: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1094: p_retained_grade|| '-' || p_retained_step ,
1095: 'Maximum Basic Pay',
1096: p_effective_date);
1097:

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

1120: -- Bug# 9255822 added PRD Y
1121: if p_to_pay_plan in ('GH', 'GM')
1122: and p_rate_determinant_code in ('2','3','4','J','K','R','Y') then
1123:
1124: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1125: p_to_grade_or_level || '-' || p_to_step_or_rate,
1126: 'Minimum Basic Pay',p_effective_date);
1127:
1128: if min_basic_pay IS NOT NULL and

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

1144: Default: Insert asterisks in pay basis and basic pay.*/
1145: if p_to_pay_plan in ('GH','GM','GS')
1146: and p_rate_determinant_code in ('2','3','4','J','K','R','Y') then
1147:
1148: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1149: p_to_grade_or_level || '-' || p_to_step_or_rate,
1150: 'Minimum Basic Pay',p_effective_date);
1151:
1152: if min_basic_pay IS NOT NULL and

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

1170: --
1171: IF p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') then
1172: if p_to_pay_plan in ('FB', 'FJ', 'FX') then
1173:
1174: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
1175: '01',
1176: 'Maximum Basic Pay',
1177: p_effective_date);
1178:

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

1175: '01',
1176: 'Maximum Basic Pay',
1177: p_effective_date);
1178:
1179: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
1180: '06',
1181: 'Maximum Basic Pay',
1182: p_effective_date);
1183: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

1197: be asterisks.*/
1198: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1199: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1200: if p_to_pay_plan = 'FT' then
1201: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1202: p_to_pay_plan ,
1203: 'Minimum Basic Pay',
1204: p_effective_date);
1205:

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

1202: p_to_pay_plan ,
1203: 'Minimum Basic Pay',
1204: p_effective_date);
1205:
1206: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1207: p_to_pay_plan ,
1208: 'Maximum Basic Pay',
1209: p_effective_date);
1210:

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

1231: -- 18/10/2004 Madhuri From the start of the edit Deleting the edit
1232: -----------------------------------------------------------------------------------------------------------
1233:
1234: /*if p_to_pay_plan in ('FL', 'FS', 'FW') then
1235: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1236: 'WG' || '-' || p_to_grade_or_level,
1237: 'Minimum Basic Pay',p_effective_date);
1238:
1239: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1235: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1236: 'WG' || '-' || p_to_grade_or_level,
1237: 'Minimum Basic Pay',p_effective_date);
1238:
1239: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1240: 'WS' || '-' || p_to_grade_or_level,
1241: 'Maximum Basic Pay',p_effective_date);
1242:
1243: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

1263: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1264: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
1265: if p_to_pay_plan = 'FM' then
1266:
1267: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1268: p_to_grade_or_level,
1269: 'Minimum Basic Pay',p_effective_date);
1270:
1271: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1267: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1268: p_to_grade_or_level,
1269: 'Minimum Basic Pay',p_effective_date);
1270:
1271: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1272: p_to_grade_or_level,
1273: 'Maximum Basic Pay',p_effective_date);
1274: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1275: if p_rate_determinant_code in ('0','7')

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

1284: end if;
1285: else
1286: if p_to_pay_plan = 'FM' then
1287:
1288: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1289: p_to_grade_or_level || '-' || p_to_step_or_rate,
1290: 'Minimum Basic Pay',p_effective_date);
1291:
1292: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1288: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1289: p_to_grade_or_level || '-' || p_to_step_or_rate,
1290: 'Minimum Basic Pay',p_effective_date);
1291:
1292: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1293: p_to_grade_or_level || '-' || p_to_step_or_rate,
1294: 'Maximum Basic Pay',p_effective_date);
1295: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1296: if p_rate_determinant_code in ('0','7')

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

1315:
1316: if p_to_pay_plan = 'DR' and
1317: p_rate_determinant_code in ('0','7') then
1318:
1319: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
1320: p_to_grade_or_level ,
1321: 'Minimum Basic Pay',p_effective_date);
1322:
1323: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',

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

1319: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
1320: p_to_grade_or_level ,
1321: 'Minimum Basic Pay',p_effective_date);
1322:
1323: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
1324: p_to_grade_or_level ,
1325: 'Maximum Basic Pay',p_effective_date);
1326:
1327: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1345:
1346: if p_to_pay_plan = 'DR' and
1347: p_rate_determinant_code in ('5','6') then
1348:
1349: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
1350: p_to_grade_or_level ,
1351: 'Minimum Basic Pay',p_effective_date);
1352:
1353: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',

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

1349: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
1350: p_to_grade_or_level ,
1351: 'Minimum Basic Pay',p_effective_date);
1352:
1353: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
1354: p_to_grade_or_level ,
1355: 'Maximum Basic Pay',p_effective_date);
1356:
1357: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1376: /* Commenting the edit for the bug 3147737
1377: if p_to_pay_plan = 'GG' and
1378: p_rate_determinant_code in ('5','6','M') then
1379:
1380: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',p_to_grade_or_level,
1381: 'Maximum Basic Pay',p_effective_date);
1382:
1383: if max_basic_pay IS NOT NULL and
1384: (not(to_number(p_to_basic_pay) < max_basic_pay)

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

1401: if p_to_pay_plan = 'GG' and
1402: p_to_grade_or_level between '01' and '15' and
1403: p_rate_determinant_code in ('2','3','4','J','K','R','Y') then
1404:
1405: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1406: p_to_grade_or_level || '-' || p_to_step_or_rate ,
1407: 'Minimum Basic Pay',
1408: p_effective_date);
1409: if min_basic_pay IS NOT NULL

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

1428: and p_agency_subelement = 'ST'
1429: and p_rate_determinant_code = '0'
1430: and p_to_step_or_rate in ('13','14') then
1431:
1432: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',
1433: p_to_step_or_rate ,
1434: 'Maximum Basic Pay',p_effective_date);
1435:
1436: if max_basic_pay IS NOT NULL

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

1464: and p_agency_subelement = 'ST'
1465: and p_rate_determinant_code = '0'
1466: and p_to_grade_or_level in ('13','14') then
1467:
1468: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',
1469: p_to_step_or_rate ,
1470: 'Maximum Basic Pay',p_effective_date);
1471:
1472: if max_basic_pay IS NOT NULL

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

1488: Default: Insert asterisks in pay basis and basic pay.*/
1489: if p_to_pay_plan = 'GH'
1490: and p_rate_determinant_code in ('0','7') then
1491:
1492: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1493: p_to_grade_or_level || '-' || p_to_step_or_rate,
1494: 'Minimum Basic Pay',p_effective_date);
1495: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1496: p_to_grade_or_level || '-' || p_to_step_or_rate,

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

1491:
1492: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1493: p_to_grade_or_level || '-' || p_to_step_or_rate,
1494: 'Minimum Basic Pay',p_effective_date);
1495: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1496: p_to_grade_or_level || '-' || p_to_step_or_rate,
1497: 'Maximum Basic Pay',p_effective_date);
1498:
1499: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

1517:
1518: /*if p_to_pay_plan = 'GH'
1519: and p_rate_determinant_code in ('5', '6', 'M') then
1520:
1521: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1522: p_to_grade_or_level,
1523: 'Minimum Basic Pay',p_effective_date);
1524:
1525: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',

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

1521: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1522: p_to_grade_or_level,
1523: 'Minimum Basic Pay',p_effective_date);
1524:
1525: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1526: p_to_grade_or_level,
1527: 'Maximum Basic Pay',p_effective_date);
1528:
1529: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

1547: -- from Then Basic Pay must equal the entry for the grade on Table 8 or be asterisks.
1548: -- to Then Basic Pay must be within the range for the grade on Table 8 or be asterisks.
1549:
1550: if p_to_pay_plan = 'FC' and p_rate_determinant_code = '0' then
1551: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1552: p_to_grade_or_level || '-' || p_to_step_or_rate,
1553: 'Minimum Basic Pay',p_effective_date);
1554:
1555: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

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

1551: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1552: p_to_grade_or_level || '-' || p_to_step_or_rate,
1553: 'Minimum Basic Pay',p_effective_date);
1554:
1555: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1556: p_to_grade_or_level || '-' || p_to_step_or_rate,
1557: 'Maximum Basic Pay',p_effective_date);
1558:
1559: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1579: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1580: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1581: if p_to_pay_plan = 'FC' and p_rate_determinant_code <> 'C' then
1582:
1583: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1584: p_to_grade_or_level || '-' || p_to_step_or_rate,
1585: 'Minimum Basic Pay',p_effective_date);
1586:
1587: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

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

1583: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1584: p_to_grade_or_level || '-' || p_to_step_or_rate,
1585: 'Minimum Basic Pay',p_effective_date);
1586:
1587: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1588: p_to_grade_or_level || '-' || p_to_step_or_rate,
1589: 'Maximum Basic Pay',p_effective_date);
1590:
1591: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1610: if p_to_pay_plan = 'GG' and
1611: p_to_grade_or_level = 'SL' and
1612: p_rate_determinant_code = '0' then
1613:
1614: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1615: p_to_pay_plan ,'Minimum Basic Pay',p_effective_date);
1616:
1617: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1618: p_to_pay_plan ,'Maximum Basic Pay',p_effective_date);

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

1613:
1614: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1615: p_to_pay_plan ,'Minimum Basic Pay',p_effective_date);
1616:
1617: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1618: p_to_pay_plan ,'Maximum Basic Pay',p_effective_date);
1619:
1620: if max_basic_pay IS NOT NULL and min_basic_pay is not null and
1621: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1637: Default: Insert asterisks in pay basis and basic pay.
1638: if p_to_pay_plan = 'ND' and
1639: p_rate_determinant_code in ('0','5','6','7') then
1640: if p_rate_determinant_code in ('0','7') then
1641: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1642: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1643: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1644: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1645: elsif p_rate_determinant_code in ('5','6') then

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

1639: p_rate_determinant_code in ('0','5','6','7') then
1640: if p_rate_determinant_code in ('0','7') then
1641: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1642: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1643: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1644: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1645: elsif p_rate_determinant_code in ('5','6') then
1646: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1647: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);

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

1642: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1643: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1644: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1645: elsif p_rate_determinant_code in ('5','6') then
1646: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1647: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1648: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1649: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1650: end if;

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

1644: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1645: elsif p_rate_determinant_code in ('5','6') then
1646: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1647: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1648: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1649: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1650: end if;
1651: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1652: and not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1669: Default: Insert asterisks in pay basis and basic pay.
1670: if p_to_pay_plan = 'NG' and
1671: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1672: if p_rate_determinant_code in ('0','7') then
1673: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1674: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1675: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1676: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1677: elsif p_rate_determinant_code in ('5','6') then

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

1671: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1672: if p_rate_determinant_code in ('0','7') then
1673: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1674: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1675: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1676: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1677: elsif p_rate_determinant_code in ('5','6') then
1678: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1679: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);

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

1674: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1675: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1676: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1677: elsif p_rate_determinant_code in ('5','6') then
1678: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1679: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1680: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1681: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1682: end if;

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

1676: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1677: elsif p_rate_determinant_code in ('5','6') then
1678: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1679: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1680: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1681: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1682: end if;
1683: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1684: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1701: Default: Insert asterisks in pay basis and basic pay.
1702: if p_to_pay_plan = 'NT' and
1703: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1704: if p_rate_determinant_code in ('0','7') then
1705: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1706: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1707: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1708: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1709: elsif p_rate_determinant_code in ('5','6') then

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

1703: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1704: if p_rate_determinant_code in ('0','7') then
1705: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1706: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1707: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1708: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1709: elsif p_rate_determinant_code in ('5','6') then
1710: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1711: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);

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

1706: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1707: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1708: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1709: elsif p_rate_determinant_code in ('5','6') then
1710: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1711: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1712: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1713: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1714: end if;

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

1708: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1709: elsif p_rate_determinant_code in ('5','6') then
1710: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1711: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1712: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1713: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1714: end if;
1715: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1716: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1731: Default: Insert asterisks in pay basis and basic pay.*/
1732: if p_to_pay_plan in ('AF','FO','FP') and
1733: p_rate_determinant_code = '0' then
1734:
1735: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
1736: p_to_grade_or_level || '-' || p_to_step_or_rate,
1737: 'Minimum Basic Pay',p_effective_date);
1738:
1739: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',

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

1735: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
1736: p_to_grade_or_level || '-' || p_to_step_or_rate,
1737: 'Minimum Basic Pay',p_effective_date);
1738:
1739: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
1740: p_to_grade_or_level || '-' || p_to_step_or_rate,
1741: 'Maximum Basic Pay',p_effective_date);
1742:
1743: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1768: max_basic_pay := NULL;
1769: min_basic_pay := NULL;
1770: if substr(p_to_pay_plan,1,1) = 'W' and
1771: p_to_pay_plan not in ('WG','WL','WM','WS') then
1772: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1773: substr(p_to_pay_plan,1,1),
1774: 'Maximum Basic Pay',
1775: p_effective_date);
1776: elsif p_to_pay_plan = 'XE' then

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

1773: substr(p_to_pay_plan,1,1),
1774: 'Maximum Basic Pay',
1775: p_effective_date);
1776: elsif p_to_pay_plan = 'XE' then
1777: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1778: p_to_pay_plan,
1779: 'Minimum Basic Pay',
1780: p_effective_date);
1781: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1777: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1778: p_to_pay_plan,
1779: 'Minimum Basic Pay',
1780: p_effective_date);
1781: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1782: p_to_pay_plan,
1783: 'Maximum Basic Pay',
1784: p_effective_date);
1785: else

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

1782: p_to_pay_plan,
1783: 'Maximum Basic Pay',
1784: p_effective_date);
1785: else
1786: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1787: p_to_pay_plan ||'-'|| p_to_grade_or_level,
1788: 'Minimum Basic Pay',
1789: p_effective_date);
1790: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1786: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1787: p_to_pay_plan ||'-'|| p_to_grade_or_level,
1788: 'Minimum Basic Pay',
1789: p_effective_date);
1790: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1791: p_to_pay_plan||'-'|| p_to_grade_or_level,
1792: 'Maximum Basic Pay',
1793: p_effective_date);
1794: end if;

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

1817: if substr(p_retained_pay_plan,1,1) = 'W' or p_retained_pay_plan in ('XF','XG','XH') then
1818: if substr(p_retained_pay_plan,1,1) = 'W' and
1819: p_retained_pay_plan not in ('WG','WL','WM','WS') then
1820: min_basic_pay := 0; -- no check in table
1821: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1822: substr(p_retained_pay_plan,1,1),
1823: 'Maximum Basic Pay',p_effective_date);
1824: else
1825: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1821: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1822: substr(p_retained_pay_plan,1,1),
1823: 'Maximum Basic Pay',p_effective_date);
1824: else
1825: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1826: p_retained_pay_plan ||'-'|| p_retained_grade,
1827: 'Minimum Basic Pay',p_effective_date);
1828: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1829: p_retained_pay_plan||'-'|| p_retained_grade,

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

1824: else
1825: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1826: p_retained_pay_plan ||'-'|| p_retained_grade,
1827: 'Minimum Basic Pay',p_effective_date);
1828: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1829: p_retained_pay_plan||'-'|| p_retained_grade,
1830: 'Maximum Basic Pay',p_effective_date);
1831: end if;
1832: if max_basic_pay IS NOT NULL then

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

1843: if substr(p_retained_pay_plan,1,1) = 'W' or p_retained_pay_plan in ('XF','XG','XH','XE') then
1844: if substr(p_retained_pay_plan,1,1) = 'W' and
1845: p_retained_pay_plan not in ('WG','WL','WM','WS') then
1846: min_basic_pay := 0; -- no check in table
1847: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1848: substr(p_retained_pay_plan,1,1),
1849: 'Maximum Basic Pay',p_effective_date);
1850: elsif p_retained_pay_plan = 'XE' then
1851: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1847: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1848: substr(p_retained_pay_plan,1,1),
1849: 'Maximum Basic Pay',p_effective_date);
1850: elsif p_retained_pay_plan = 'XE' then
1851: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1852: p_retained_pay_plan,
1853: 'Minimum Basic Pay',p_effective_date);
1854: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1855: p_retained_pay_plan,

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

1850: elsif p_retained_pay_plan = 'XE' then
1851: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1852: p_retained_pay_plan,
1853: 'Minimum Basic Pay',p_effective_date);
1854: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1855: p_retained_pay_plan,
1856: 'Maximum Basic Pay',p_effective_date);
1857: else
1858: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1854: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1855: p_retained_pay_plan,
1856: 'Maximum Basic Pay',p_effective_date);
1857: else
1858: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1859: p_retained_pay_plan ||'-'|| p_retained_grade,
1860: 'Minimum Basic Pay',p_effective_date);
1861: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1862: p_retained_pay_plan||'-'|| p_retained_grade,

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

1857: else
1858: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1859: p_retained_pay_plan ||'-'|| p_retained_grade,
1860: 'Minimum Basic Pay',p_effective_date);
1861: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1862: p_retained_pay_plan||'-'|| p_retained_grade,
1863: 'Maximum Basic Pay',p_effective_date);
1864: end if;
1865: if max_basic_pay IS NOT NULL then

Line 1890: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',

1886: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1887: if p_to_pay_plan = 'VM'
1888: and p_rate_determinant_code = '0' then
1889:
1890: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1891: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1892: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1893: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1894:

Line 1892: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',

1888: and p_rate_determinant_code = '0' then
1889:
1890: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1891: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1892: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1893: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1894:
1895: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1896: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

Line 1919: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',

1915:
1916: /*if p_to_pay_plan = 'VP'
1917: and p_rate_determinant_code = '0' then
1918:
1919: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1920: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1921: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1922: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1923:

Line 1921: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',

1917: and p_rate_determinant_code = '0' then
1918:
1919: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1920: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1921: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1922: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1923:
1924: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1925: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

Line 1944: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',

1940: Default: Insert asterisks in pay basis and basic pay.
1941: if p_to_pay_plan = 'VN'
1942: and p_rate_determinant_code = '0' then
1943:
1944: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1945: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1946: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1947: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1948:

Line 1946: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',

1942: and p_rate_determinant_code = '0' then
1943:
1944: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1945: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1946: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1947: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1948:
1949: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1950: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

Line 1977: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',

1973: if p_to_pay_plan = 'SR' and
1974: substr(p_agency_subelement,1,2) = 'VA' and
1975: p_rate_determinant_code = '0' then
1976:
1977: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1978: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1979: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1980: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1981:

Line 1979: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',

1975: p_rate_determinant_code = '0' then
1976:
1977: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1978: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1979: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1980: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1981:
1982: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1983: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

2002: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
2003: if p_to_pay_plan = 'NC' then
2004: if p_rate_determinant_code in ('0','7') then
2005:
2006: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
2007: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
2009: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2010:

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

2004: if p_rate_determinant_code in ('0','7') then
2005:
2006: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
2007: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
2009: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2010:
2011: elsif p_rate_determinant_code in ('5','6') then
2012: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',

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

2008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
2009: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2010:
2011: elsif p_rate_determinant_code in ('5','6') then
2012: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
2013: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2014: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
2015: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2016: end if;

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

2010:
2011: elsif p_rate_determinant_code in ('5','6') then
2012: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
2013: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2014: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
2015: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2016: end if;
2017: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2018: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

2038: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
2039: if p_to_pay_plan = 'NO' then
2040: if p_rate_determinant_code in ('0','7') then
2041:
2042: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
2043: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2044: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
2045: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2046:

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

2040: if p_rate_determinant_code in ('0','7') then
2041:
2042: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
2043: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2044: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
2045: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2046:
2047: elsif p_rate_determinant_code in ('5','6') then
2048: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',

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

2044: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
2045: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2046:
2047: elsif p_rate_determinant_code in ('5','6') then
2048: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
2049: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2050: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
2051: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2052: end if;

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

2046:
2047: elsif p_rate_determinant_code in ('5','6') then
2048: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
2049: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2050: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
2051: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2052: end if;
2053: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2054: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

2075: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
2076: if p_to_pay_plan = 'NP' then
2077: if p_rate_determinant_code in ('0','7') then
2078:
2079: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
2080: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2081: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
2082: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2083:

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

2077: if p_rate_determinant_code in ('0','7') then
2078:
2079: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
2080: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2081: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
2082: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2083:
2084: elsif p_rate_determinant_code in ('5','6') then
2085: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',

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

2081: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
2082: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2083:
2084: elsif p_rate_determinant_code in ('5','6') then
2085: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
2086: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2087: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
2088: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2089: end if;

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

2083:
2084: elsif p_rate_determinant_code in ('5','6') then
2085: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
2086: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2087: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 49',
2088: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2089: end if;
2090: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2091: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

2111: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
2112: if p_to_pay_plan = 'NR' then
2113: if p_rate_determinant_code in ('0','7') then
2114:
2115: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
2116: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2117: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
2118: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2119:

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

2113: if p_rate_determinant_code in ('0','7') then
2114:
2115: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
2116: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2117: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
2118: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2119:
2120: elsif p_rate_determinant_code in ('5','6') then
2121: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',

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

2117: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
2118: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2119:
2120: elsif p_rate_determinant_code in ('5','6') then
2121: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
2122: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2123: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
2124: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2125: end if;

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

2119:
2120: elsif p_rate_determinant_code in ('5','6') then
2121: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
2122: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2123: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 51',
2124: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2125: end if;
2126: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2127: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

2145: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
2146: -------------------------------------------------------------------------------
2147: IF p_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
2148: if p_to_pay_plan = 'KA' then
2149: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
2150: p_to_pay_plan ,
2151: 'Minimum Basic Pay',p_effective_date);
2152:
2153: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

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

2149: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
2150: p_to_pay_plan ,
2151: 'Minimum Basic Pay',p_effective_date);
2152:
2153: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
2154: p_to_pay_plan ,
2155: 'Maximum Basic Pay',p_effective_date);
2156:
2157: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

2181: if p_agency_subelement = 'DD16' and
2182: p_to_pay_plan in ('AD', 'TP') and
2183: p_to_pay_basis in ('PD','SY') then
2184:
2185: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
2186: p_to_pay_plan ,
2187: 'Minimum Basic Pay',
2188: p_effective_date);
2189: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',

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

2185: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
2186: p_to_pay_plan ,
2187: 'Minimum Basic Pay',
2188: p_effective_date);
2189: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
2190: p_to_pay_plan ,
2191: 'Maximum Basic Pay',
2192: p_effective_date);
2193: if max_basic_pay IS NOT NULL and

Line 2208: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',

2204: if p_agency_subelement = 'DD16' and
2205: p_to_pay_plan in ('AD', 'TP') and
2206: p_to_pay_basis in ('PD','SY') then
2207:
2208: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',
2209: p_to_pay_plan ,
2210: 'Minimum Basic Pay',
2211: p_effective_date);
2212: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',

Line 2212: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',

2208: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',
2209: p_to_pay_plan ,
2210: 'Minimum Basic Pay',
2211: p_effective_date);
2212: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',
2213: p_to_pay_plan ,
2214: 'Maximum Basic Pay',
2215: p_effective_date);
2216: if max_basic_pay IS NOT NULL and

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

2242: and p_retained_pay_plan in ('GS','GG')
2243: and p_retained_step between '01' and '10'
2244: and p_rate_determinant_code in ('E','F','M') then
2245:
2246: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
2247: p_retained_grade,
2248: 'Maximum Basic Pay',p_effective_date);
2249:
2250: if max_basic_pay IS NOT NULL and

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

2273: if not(p_to_pay_plan in ('GH','GM'))
2274: and p_retained_pay_plan in ('GH','GM')
2275: and p_rate_determinant_code in ('A','B') then
2276:
2277: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2278: p_retained_grade ||'-'|| p_retained_step,
2279: 'Minimum Basic Pay',p_effective_date);
2280: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2281: p_retained_grade ||'-'|| p_retained_step,

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

2276:
2277: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2278: p_retained_grade ||'-'|| p_retained_step,
2279: 'Minimum Basic Pay',p_effective_date);
2280: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2281: p_retained_grade ||'-'|| p_retained_step,
2282: 'Maximum Basic Pay',p_effective_date);
2283:
2284: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

2306:
2307: if p_to_pay_plan = 'GS'
2308: and p_rate_determinant_code in ('5','6','M') then
2309:
2310: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
2311: p_to_grade_or_level,
2312: 'Maximum Basic Pay',p_effective_date);
2313:
2314: if max_basic_pay IS NOT NULL

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

2335: if not(p_to_pay_plan in ('GM','GH'))
2336: and p_retained_pay_plan in ('GM','GH')
2337: and p_rate_determinant_code in ('E','F','M') then
2338:
2339: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2340: p_retained_grade,
2341: 'Minimum Basic Pay',p_effective_date);
2342:
2343: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',

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

2339: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2340: p_retained_grade,
2341: 'Minimum Basic Pay',p_effective_date);
2342:
2343: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2344: p_retained_grade,
2345: 'Maximum Basic Pay',p_effective_date);
2346:
2347: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2370: and p_retained_pay_plan in ('GS','GG')
2371: and p_rate_determinant_code in ('E','F','M')
2372: and p_retained_step between '01' and '10' then
2373:
2374: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
2375: p_retained_grade,
2376: 'Maximum Basic Pay',p_effective_date);
2377:
2378: if max_basic_pay IS NOT NULL

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

2399: if p_to_pay_plan in ('GM','GH')
2400: and p_retained_pay_plan in ('GM','GH')
2401: and p_rate_determinant_code in ('E','F','M') then
2402:
2403: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2404: p_retained_grade,
2405: 'Minimum Basic Pay',p_effective_date);
2406: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2407: p_retained_grade,

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

2402:
2403: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2404: p_retained_grade,
2405: 'Minimum Basic Pay',p_effective_date);
2406: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2407: p_retained_grade,
2408: 'Maximum Basic Pay',p_effective_date);
2409:
2410: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2430:
2431: if p_to_pay_plan = 'AL'
2432: and p_rate_determinant_code <> 'C' then
2433: if p_to_grade_or_level in ('01', '02') then
2434: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
2435: p_to_grade_or_level,
2436: 'Maximum Basic Pay',
2437: p_effective_date);
2438: else

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

2435: p_to_grade_or_level,
2436: 'Maximum Basic Pay',
2437: p_effective_date);
2438: else
2439: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
2440: p_to_grade_or_level || '-' ||p_to_step_or_rate,
2441: 'Maximum Basic Pay',
2442: p_effective_date);
2443: end if;

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

2461: Basis for Edit: 5 U.S.C. 5372a*/
2462: if p_to_pay_plan = 'CA'
2463: and p_rate_determinant_code <> 'C' then
2464:
2465: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 23',
2466: p_to_grade_or_level,
2467: 'Minimum Basic Pay',p_effective_date);
2468:
2469: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2489: if p_effective_date < fnd_date.canonical_to_date('2008/10/14') then
2490: if p_to_pay_plan in ('ST', 'SL')
2491: and p_rate_determinant_code NOT IN ('C') then
2492:
2493: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2494: p_to_pay_plan ,
2495: 'Minimum Basic Pay',p_effective_date);
2496:
2497: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

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

2493: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2494: p_to_pay_plan ,
2495: 'Minimum Basic Pay',p_effective_date);
2496:
2497: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2498: p_to_pay_plan ,
2499: 'Maximum Basic Pay',p_effective_date);
2500:
2501: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2511: else
2512: if p_to_pay_plan in ('ST', 'SL')
2513: and p_rate_determinant_code NOT IN ('C','D') then
2514:
2515: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2516: p_to_pay_plan ,
2517: 'Minimum Basic Pay',p_effective_date);
2518:
2519: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

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

2515: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2516: p_to_pay_plan ,
2517: 'Minimum Basic Pay',p_effective_date);
2518:
2519: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2520: p_to_pay_plan ,
2521: 'Maximum Basic Pay',p_effective_date);
2522:
2523: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2543: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2544: if p_to_pay_plan = 'IJ' and
2545: p_rate_determinant_code in ('0','7') then
2546:
2547: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 36',
2548: p_to_step_or_rate ,
2549: 'Maximum Basic Pay',
2550: p_effective_date);
2551: if max_basic_pay IS NOT NULL and

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

2568: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2569: if p_to_pay_plan in ('AF','FO','FP')
2570: and p_rate_determinant_code <> 'C' then
2571:
2572: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
2573: p_to_grade_or_level || '-' || p_to_step_or_rate,
2574: 'Minimum Basic Pay',p_effective_date);
2575:
2576: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',

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

2572: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
2573: p_to_grade_or_level || '-' || p_to_step_or_rate,
2574: 'Minimum Basic Pay',p_effective_date);
2575:
2576: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
2577: p_to_grade_or_level || '-' || p_to_step_or_rate,
2578: 'Maximum Basic Pay',p_effective_date);
2579:
2580: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2602: p_rate_determinant_code not in ('A','B','E','F','U','V') then
2603: max_basic_pay := NULL;
2604: min_basic_pay := NULL;
2605: if substr(p_to_pay_plan,1,1) = 'W' and p_to_pay_plan not in ('WG','WL','WM','WS') then
2606: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2607: substr(p_to_pay_plan,1,1),
2608: 'Minimum Basic Pay',p_effective_date);
2609: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2610: substr(p_to_pay_plan,1,1),

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

2605: if substr(p_to_pay_plan,1,1) = 'W' and p_to_pay_plan not in ('WG','WL','WM','WS') then
2606: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2607: substr(p_to_pay_plan,1,1),
2608: 'Minimum Basic Pay',p_effective_date);
2609: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2610: substr(p_to_pay_plan,1,1),
2611: 'Maximum Basic Pay',p_effective_date);
2612: elsif p_to_pay_plan = 'XE' then
2613: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

2609: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2610: substr(p_to_pay_plan,1,1),
2611: 'Maximum Basic Pay',p_effective_date);
2612: elsif p_to_pay_plan = 'XE' then
2613: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2614: p_to_pay_plan,
2615: 'Minimum Basic Pay',p_effective_date);
2616: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2617: p_to_pay_plan,

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

2612: elsif p_to_pay_plan = 'XE' then
2613: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2614: p_to_pay_plan,
2615: 'Minimum Basic Pay',p_effective_date);
2616: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2617: p_to_pay_plan,
2618: 'Maximum Basic Pay',p_effective_date);
2619: else
2620: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

2616: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2617: p_to_pay_plan,
2618: 'Maximum Basic Pay',p_effective_date);
2619: else
2620: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2621: p_to_pay_plan ||'-'|| p_to_grade_or_level,
2622: 'Minimum Basic Pay',p_effective_date);
2623: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2624: p_to_pay_plan ||'-'|| p_to_grade_or_level,

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

2619: else
2620: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2621: p_to_pay_plan ||'-'|| p_to_grade_or_level,
2622: 'Minimum Basic Pay',p_effective_date);
2623: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2624: p_to_pay_plan ||'-'|| p_to_grade_or_level,
2625: 'Maximum Basic Pay',p_effective_date);
2626: end if;
2627: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

Line 2654: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',

2650: if p_to_pay_plan = 'SR' and
2651: substr(p_agency_subelement,1,2) = 'VA' and
2652: p_rate_determinant_code <> 'C' then
2653:
2654: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2655: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2656: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2657: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2658:

Line 2656: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',

2652: p_rate_determinant_code <> 'C' then
2653:
2654: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2655: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2656: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2657: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2658:
2659: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2660: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

Line 2671: end ghr_cpdf_check8;

2667: end if;
2668: end if;
2669: hr_utility.set_location('Leaving CPDF 8 ',1);
2670: end basic_pay;
2671: end ghr_cpdf_check8;