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.4.12000000.3 2007/02/14 11:28:08 utokachi noship $ */
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 200: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 5',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

447: then basic pay must be within the range on Table 15 */
448: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
449: if ( p_to_pay_plan = 'VN' and p_rate_determinant_code = '0'
450: and p_occupation_code in ('0605','0610') ) then
451: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',
452: p_to_pay_plan,
453: 'Minimum Basic Pay',
454: p_effective_date);
455: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 15',

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

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

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

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

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

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

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

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

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

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

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

751:
752: Default: Insert asterisks in pay basis and basic pay.*/
753: if p_to_pay_plan = 'NY' then
754:
755: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
756: p_to_grade_or_level ,
757: 'Minimum Basic Pay',p_effective_date);
758:
759: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',

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

755: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
756: p_to_grade_or_level ,
757: 'Minimum Basic Pay',p_effective_date);
758:
759: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
760: p_to_grade_or_level ,
761: 'Maximum Basic Pay',p_effective_date);
762:
763: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

777: Default: Insert asterisks in pay basis and basic pay.*/
778:
779: if p_to_pay_plan = 'NX' then
780:
781: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
782: p_to_grade_or_level ,
783: 'Minimum Basic Pay',p_effective_date);
784:
785: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',

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

781: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
782: p_to_grade_or_level ,
783: 'Minimum Basic Pay',p_effective_date);
784:
785: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
786: p_to_grade_or_level ,
787: 'Maximum Basic Pay',p_effective_date);
788:
789: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

806: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
807: p_to_pay_plan = 'NJ' and
808: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
809: if p_rate_determinant_code in ('0','7') then
810: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
811: p_to_grade_or_level ,
812: 'Minimum Basic Pay',p_effective_date);
813: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
814: p_to_grade_or_level ,

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

809: if p_rate_determinant_code in ('0','7') then
810: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
811: p_to_grade_or_level ,
812: 'Minimum Basic Pay',p_effective_date);
813: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
814: p_to_grade_or_level ,
815: 'Maximum Basic Pay',p_effective_date);
816: elsif p_rate_determinant_code in ('5','6') then
817: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',

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

813: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
814: p_to_grade_or_level ,
815: 'Maximum Basic Pay',p_effective_date);
816: elsif p_rate_determinant_code in ('5','6') then
817: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
818: p_to_grade_or_level ,
819: 'Minimum Basic Pay',p_effective_date);
820: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
821: p_to_grade_or_level ,

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

816: elsif p_rate_determinant_code in ('5','6') then
817: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
818: p_to_grade_or_level ,
819: 'Minimum Basic Pay',p_effective_date);
820: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 40',
821: p_to_grade_or_level ,
822: 'Maximum Basic Pay',p_effective_date);
823: end if;
824: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

842: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
843: p_to_pay_plan = 'NK' and
844: p_rate_determinant_code in ('0','5','6','7') then
845: if p_rate_determinant_code in ('0','7') then
846: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
847: p_to_grade_or_level ,
848: 'Minimum Basic Pay',p_effective_date);
849: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
850: p_to_grade_or_level ,

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

845: if p_rate_determinant_code in ('0','7') then
846: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
847: p_to_grade_or_level ,
848: 'Minimum Basic Pay',p_effective_date);
849: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
850: p_to_grade_or_level ,
851: 'Maximum Basic Pay',p_effective_date);
852: elsif p_rate_determinant_code in ('5','6') then
853: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',

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

849: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
850: p_to_grade_or_level ,
851: 'Maximum Basic Pay',p_effective_date);
852: elsif p_rate_determinant_code in ('5','6') then
853: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
854: p_to_grade_or_level ,
855: 'Minimum Basic Pay',p_effective_date);
856: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
857: p_to_grade_or_level ,

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

852: elsif p_rate_determinant_code in ('5','6') then
853: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
854: p_to_grade_or_level ,
855: 'Minimum Basic Pay',p_effective_date);
856: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 42',
857: p_to_grade_or_level ,
858: 'Maximum Basic Pay',p_effective_date);
859: end if;
860: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

882:
883: if p_to_pay_plan = 'GS' and
884: p_rate_determinant_code in ('2','3','4','J','K','R') then
885:
886: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
887: p_to_grade_or_level || '-' || p_to_step_or_rate,
888: 'Minimum Basic Pay',p_effective_date);
889:
890: if min_basic_pay IS NOT NULL and

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

909: --
910: if p_rate_determinant_code in ('U','V') and
911: p_to_pay_plan in ('GG','GH','GS','GM') then
912:
913: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
914: p_retained_grade || '-' || p_retained_step,
915: 'Minimum Basic Pay',p_effective_date);
916:
917: if min_basic_pay IS NOT NULL and

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

934: Default: Insert asterisks in pay basis and basic pay.
935: if p_to_pay_plan = 'GM'
936: and p_rate_determinant_code in ('0', '7') then
937:
938: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
939: p_to_grade_or_level || '-' || p_to_step_or_rate,
940: 'Minimum Basic Pay',p_effective_date);
941:
942: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

938: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
939: p_to_grade_or_level || '-' || p_to_step_or_rate,
940: 'Minimum Basic Pay',p_effective_date);
941:
942: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
943: p_to_grade_or_level || '-' || p_to_step_or_rate,
944: 'Maximum Basic Pay',p_effective_date);
945:
946: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

962: */
963: if p_to_pay_plan = 'GM'
964: and p_rate_determinant_code in ('0', '7') then
965:
966: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
967: p_to_grade_or_level ,
968: 'Minimum Basic Pay',p_effective_date);
969:
970: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

966: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
967: p_to_grade_or_level ,
968: 'Minimum Basic Pay',p_effective_date);
969:
970: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
971: p_to_grade_or_level ,
972: 'Maximum Basic Pay',p_effective_date);
973:
974: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

989: Default: Insert asterisks in pay basis and basic pay.*/
990: /*if p_to_pay_plan = 'GM'
991: and p_rate_determinant_code in ('5', '6', 'M') then
992:
993: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
994: p_to_grade_or_level,
995: 'Minimum Basic Pay',p_effective_date);
996: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
997: p_to_grade_or_level,

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

992:
993: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
994: p_to_grade_or_level,
995: 'Minimum Basic Pay',p_effective_date);
996: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
997: p_to_grade_or_level,
998: 'Maximum Basic Pay',p_effective_date);
999:
1000: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1022: and p_rate_determinant_code in ('A','B')
1023: and p_retained_grade >= p_to_grade_or_level
1024: and p_retained_pay_plan in ('GH','GM') then
1025:
1026: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1027: p_retained_grade,
1028: 'Minimum Basic Pay',
1029: p_effective_date);
1030: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1026: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1027: p_retained_grade,
1028: 'Minimum Basic Pay',
1029: p_effective_date);
1030: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1031: p_retained_grade,
1032: 'Maximum Basic Pay',
1033: p_effective_date);
1034:

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

1047: and p_rate_determinant_code in ('A','B')
1048: and p_retained_grade >= p_to_grade_or_level
1049: and p_retained_pay_plan in ('GH','GM') then
1050:
1051: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1052: p_retained_grade|| '-' || p_retained_step,
1053: 'Minimum Basic Pay',
1054: p_effective_date);
1055: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1051: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1052: p_retained_grade|| '-' || p_retained_step,
1053: 'Minimum Basic Pay',
1054: p_effective_date);
1055: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1056: p_retained_grade|| '-' || p_retained_step ,
1057: 'Maximum Basic Pay',
1058: p_effective_date);
1059:

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

1081: Default: Insert asterisks in pay basis and basic pay.*/
1082: if p_to_pay_plan in ('GH', 'GM')
1083: and p_rate_determinant_code in ('2','3','4','J','K','R') then
1084:
1085: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1086: p_to_grade_or_level || '-' || p_to_step_or_rate,
1087: 'Minimum Basic Pay',p_effective_date);
1088:
1089: if min_basic_pay IS NOT NULL and

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

1106: --
1107: IF p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') then
1108: if p_to_pay_plan in ('FB', 'FJ', 'FX') then
1109:
1110: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
1111: '01',
1112: 'Maximum Basic Pay',
1113: p_effective_date);
1114:

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

1111: '01',
1112: 'Maximum Basic Pay',
1113: p_effective_date);
1114:
1115: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 6',
1116: '06',
1117: 'Maximum Basic Pay',
1118: p_effective_date);
1119: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

1132: Then basic pay must be within the range on Table 21 or
1133: be asterisks.*/
1134:
1135: if p_to_pay_plan = 'FT' then
1136: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1137: p_to_pay_plan ,
1138: 'Minimum Basic Pay',
1139: p_effective_date);
1140:

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

1137: p_to_pay_plan ,
1138: 'Minimum Basic Pay',
1139: p_effective_date);
1140:
1141: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1142: p_to_pay_plan ,
1143: 'Maximum Basic Pay',
1144: p_effective_date);
1145:

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

1166: -- 18/10/2004 Madhuri From the start of the edit Deleting the edit
1167: -----------------------------------------------------------------------------------------------------------
1168:
1169: /*if p_to_pay_plan in ('FL', 'FS', 'FW') then
1170: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1171: 'WG' || '-' || p_to_grade_or_level,
1172: 'Minimum Basic Pay',p_effective_date);
1173:
1174: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1170: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1171: 'WG' || '-' || p_to_grade_or_level,
1172: 'Minimum Basic Pay',p_effective_date);
1173:
1174: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1175: 'WS' || '-' || p_to_grade_or_level,
1176: 'Maximum Basic Pay',p_effective_date);
1177:
1178: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

1196: -- 17-Aug-00 vravikan 01-jan-2000 Delete step or rate
1197: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
1198: if p_to_pay_plan = 'FM' then
1199:
1200: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1201: p_to_grade_or_level,
1202: 'Minimum Basic Pay',p_effective_date);
1203:
1204: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1200: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1201: p_to_grade_or_level,
1202: 'Minimum Basic Pay',p_effective_date);
1203:
1204: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1205: p_to_grade_or_level,
1206: 'Maximum Basic Pay',p_effective_date);
1207: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1208: if p_rate_determinant_code in ('0','7')

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

1217: end if;
1218: else
1219: if p_to_pay_plan = 'FM' then
1220:
1221: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1222: p_to_grade_or_level || '-' || p_to_step_or_rate,
1223: 'Minimum Basic Pay',p_effective_date);
1224:
1225: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',

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

1221: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1222: p_to_grade_or_level || '-' || p_to_step_or_rate,
1223: 'Minimum Basic Pay',p_effective_date);
1224:
1225: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1226: p_to_grade_or_level || '-' || p_to_step_or_rate,
1227: 'Maximum Basic Pay',p_effective_date);
1228: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then
1229: if p_rate_determinant_code in ('0','7')

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

1247:
1248: if p_to_pay_plan = 'DR' and
1249: p_rate_determinant_code in ('0','7') then
1250:
1251: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
1252: p_to_grade_or_level ,
1253: 'Minimum Basic Pay',p_effective_date);
1254:
1255: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',

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

1251: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
1252: p_to_grade_or_level ,
1253: 'Minimum Basic Pay',p_effective_date);
1254:
1255: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 28',
1256: p_to_grade_or_level ,
1257: 'Maximum Basic Pay',p_effective_date);
1258:
1259: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1277:
1278: if p_to_pay_plan = 'DR' and
1279: p_rate_determinant_code in ('5','6') then
1280:
1281: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
1282: p_to_grade_or_level ,
1283: 'Minimum Basic Pay',p_effective_date);
1284:
1285: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',

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

1281: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
1282: p_to_grade_or_level ,
1283: 'Minimum Basic Pay',p_effective_date);
1284:
1285: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 29',
1286: p_to_grade_or_level ,
1287: 'Maximum Basic Pay',p_effective_date);
1288:
1289: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1308: /* Commenting the edit for the bug 3147737
1309: if p_to_pay_plan = 'GG' and
1310: p_rate_determinant_code in ('5','6','M') then
1311:
1312: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',p_to_grade_or_level,
1313: 'Maximum Basic Pay',p_effective_date);
1314:
1315: if max_basic_pay IS NOT NULL and
1316: (not(to_number(p_to_basic_pay) < max_basic_pay)

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

1332: if p_to_pay_plan = 'GG' and
1333: p_to_grade_or_level between '01' and '15' and
1334: p_rate_determinant_code in ('2','3','4','J','K','R') then
1335:
1336: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
1337: p_to_grade_or_level || '-' || p_to_step_or_rate ,
1338: 'Minimum Basic Pay',
1339: p_effective_date);
1340: if min_basic_pay IS NOT NULL

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

1359: and p_agency_subelement = 'ST'
1360: and p_rate_determinant_code = '0'
1361: and p_to_step_or_rate in ('13','14') then
1362:
1363: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',
1364: p_to_step_or_rate ,
1365: 'Maximum Basic Pay',p_effective_date);
1366:
1367: if max_basic_pay IS NOT NULL

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

1395: and p_agency_subelement = 'ST'
1396: and p_rate_determinant_code = '0'
1397: and p_to_grade_or_level in ('13','14') then
1398:
1399: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 7',
1400: p_to_step_or_rate ,
1401: 'Maximum Basic Pay',p_effective_date);
1402:
1403: if max_basic_pay IS NOT NULL

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

1419: Default: Insert asterisks in pay basis and basic pay.*/
1420: if p_to_pay_plan = 'GH'
1421: and p_rate_determinant_code in ('0','7') then
1422:
1423: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1424: p_to_grade_or_level || '-' || p_to_step_or_rate,
1425: 'Minimum Basic Pay',p_effective_date);
1426: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1427: p_to_grade_or_level || '-' || p_to_step_or_rate,

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

1422:
1423: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1424: p_to_grade_or_level || '-' || p_to_step_or_rate,
1425: 'Minimum Basic Pay',p_effective_date);
1426: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1427: p_to_grade_or_level || '-' || p_to_step_or_rate,
1428: 'Maximum Basic Pay',p_effective_date);
1429:
1430: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

1448:
1449: /*if p_to_pay_plan = 'GH'
1450: and p_rate_determinant_code in ('5', '6', 'M') then
1451:
1452: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1453: p_to_grade_or_level,
1454: 'Minimum Basic Pay',p_effective_date);
1455:
1456: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',

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

1452: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1453: p_to_grade_or_level,
1454: 'Minimum Basic Pay',p_effective_date);
1455:
1456: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
1457: p_to_grade_or_level,
1458: 'Maximum Basic Pay',p_effective_date);
1459:
1460: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

1478: -- from Then Basic Pay must equal the entry for the grade on Table 8 or be asterisks.
1479: -- to Then Basic Pay must be within the range for the grade on Table 8 or be asterisks.
1480:
1481: if p_to_pay_plan = 'FC' and p_rate_determinant_code = '0' then
1482: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1483: p_to_grade_or_level || '-' || p_to_step_or_rate,
1484: 'Minimum Basic Pay',p_effective_date);
1485:
1486: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

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

1482: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1483: p_to_grade_or_level || '-' || p_to_step_or_rate,
1484: 'Minimum Basic Pay',p_effective_date);
1485:
1486: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1487: p_to_grade_or_level || '-' || p_to_step_or_rate,
1488: 'Maximum Basic Pay',p_effective_date);
1489:
1490: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1509: -- to Then Basic Pay must be within the range for the grade on Table 8 or be asterisks.
1510:
1511: if p_to_pay_plan = 'FC' and p_rate_determinant_code <> 'C' then
1512:
1513: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1514: p_to_grade_or_level || '-' || p_to_step_or_rate,
1515: 'Minimum Basic Pay',p_effective_date);
1516:
1517: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',

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

1513: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1514: p_to_grade_or_level || '-' || p_to_step_or_rate,
1515: 'Minimum Basic Pay',p_effective_date);
1516:
1517: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1518: p_to_grade_or_level || '-' || p_to_step_or_rate,
1519: 'Maximum Basic Pay',p_effective_date);
1520:
1521: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1539: if p_to_pay_plan = 'GG' and
1540: p_to_grade_or_level = 'SL' and
1541: p_rate_determinant_code = '0' then
1542:
1543: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1544: p_to_pay_plan ,'Minimum Basic Pay',p_effective_date);
1545:
1546: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1547: p_to_pay_plan ,'Maximum Basic Pay',p_effective_date);

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

1542:
1543: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1544: p_to_pay_plan ,'Minimum Basic Pay',p_effective_date);
1545:
1546: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
1547: p_to_pay_plan ,'Maximum Basic Pay',p_effective_date);
1548:
1549: if max_basic_pay IS NOT NULL and min_basic_pay is not null and
1550: (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1566: Default: Insert asterisks in pay basis and basic pay.
1567: if p_to_pay_plan = 'ND' and
1568: p_rate_determinant_code in ('0','5','6','7') then
1569: if p_rate_determinant_code in ('0','7') then
1570: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1571: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1572: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1573: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1574: elsif p_rate_determinant_code in ('5','6') then

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

1568: p_rate_determinant_code in ('0','5','6','7') then
1569: if p_rate_determinant_code in ('0','7') then
1570: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1571: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1572: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1573: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1574: elsif p_rate_determinant_code in ('5','6') then
1575: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1576: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);

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

1571: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1572: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 30',
1573: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1574: elsif p_rate_determinant_code in ('5','6') then
1575: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1576: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1577: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1578: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1579: end if;

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

1573: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1574: elsif p_rate_determinant_code in ('5','6') then
1575: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1576: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1577: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 31',
1578: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1579: end if;
1580: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1581: and not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1598: Default: Insert asterisks in pay basis and basic pay.
1599: if p_to_pay_plan = 'NG' and
1600: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1601: if p_rate_determinant_code in ('0','7') then
1602: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1603: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1604: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1605: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1606: elsif p_rate_determinant_code in ('5','6') then

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

1600: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1601: if p_rate_determinant_code in ('0','7') then
1602: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1603: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1604: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1605: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1606: elsif p_rate_determinant_code in ('5','6') then
1607: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1608: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);

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

1603: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1604: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 32',
1605: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1606: elsif p_rate_determinant_code in ('5','6') then
1607: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1608: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1609: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1610: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1611: end if;

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

1605: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1606: elsif p_rate_determinant_code in ('5','6') then
1607: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1608: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1609: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 33',
1610: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1611: end if;
1612: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1613: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1630: Default: Insert asterisks in pay basis and basic pay.
1631: if p_to_pay_plan = 'NT' and
1632: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1633: if p_rate_determinant_code in ('0','7') then
1634: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1635: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1636: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1637: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1638: elsif p_rate_determinant_code in ('5','6') then

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

1632: p_rate_determinant_code in ('0','5','6','7') then -- added for bug 726125
1633: if p_rate_determinant_code in ('0','7') then
1634: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1635: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1636: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1637: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1638: elsif p_rate_determinant_code in ('5','6') then
1639: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1640: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);

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

1635: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1636: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 34',
1637: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1638: elsif p_rate_determinant_code in ('5','6') then
1639: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1640: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1641: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1642: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1643: end if;

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

1637: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1638: elsif p_rate_determinant_code in ('5','6') then
1639: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1640: p_to_grade_or_level ,'Minimum Basic Pay',p_effective_date);
1641: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 35',
1642: p_to_grade_or_level ,'Maximum Basic Pay',p_effective_date);
1643: end if;
1644: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1645: and (not(to_number(p_to_basic_pay) between min_basic_pay and max_basic_pay)

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

1660: Default: Insert asterisks in pay basis and basic pay.*/
1661: if p_to_pay_plan in ('AF','FO','FP') and
1662: p_rate_determinant_code = '0' then
1663:
1664: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
1665: p_to_grade_or_level || '-' || p_to_step_or_rate,
1666: 'Minimum Basic Pay',p_effective_date);
1667:
1668: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',

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

1664: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
1665: p_to_grade_or_level || '-' || p_to_step_or_rate,
1666: 'Minimum Basic Pay',p_effective_date);
1667:
1668: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
1669: p_to_grade_or_level || '-' || p_to_step_or_rate,
1670: 'Maximum Basic Pay',p_effective_date);
1671:
1672: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

1697: max_basic_pay := NULL;
1698: min_basic_pay := NULL;
1699: if substr(p_to_pay_plan,1,1) = 'W' and
1700: p_to_pay_plan not in ('WG','WL','WM','WS') then
1701: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1702: substr(p_to_pay_plan,1,1),
1703: 'Maximum Basic Pay',
1704: p_effective_date);
1705: elsif p_to_pay_plan = 'XE' then

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

1702: substr(p_to_pay_plan,1,1),
1703: 'Maximum Basic Pay',
1704: p_effective_date);
1705: elsif p_to_pay_plan = 'XE' then
1706: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1707: p_to_pay_plan,
1708: 'Minimum Basic Pay',
1709: p_effective_date);
1710: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1706: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1707: p_to_pay_plan,
1708: 'Minimum Basic Pay',
1709: p_effective_date);
1710: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1711: p_to_pay_plan,
1712: 'Maximum Basic Pay',
1713: p_effective_date);
1714: else

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

1711: p_to_pay_plan,
1712: 'Maximum Basic Pay',
1713: p_effective_date);
1714: else
1715: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1716: p_to_pay_plan ||'-'|| p_to_grade_or_level,
1717: 'Minimum Basic Pay',
1718: p_effective_date);
1719: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1715: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1716: p_to_pay_plan ||'-'|| p_to_grade_or_level,
1717: 'Minimum Basic Pay',
1718: p_effective_date);
1719: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1720: p_to_pay_plan||'-'|| p_to_grade_or_level,
1721: 'Maximum Basic Pay',
1722: p_effective_date);
1723: end if;

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

1746: if substr(p_retained_pay_plan,1,1) = 'W' or p_retained_pay_plan in ('XF','XG','XH') then
1747: if substr(p_retained_pay_plan,1,1) = 'W' and
1748: p_retained_pay_plan not in ('WG','WL','WM','WS') then
1749: min_basic_pay := 0; -- no check in table
1750: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1751: substr(p_retained_pay_plan,1,1),
1752: 'Maximum Basic Pay',p_effective_date);
1753: else
1754: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

1750: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1751: substr(p_retained_pay_plan,1,1),
1752: 'Maximum Basic Pay',p_effective_date);
1753: else
1754: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1755: p_retained_pay_plan ||'-'|| p_retained_grade,
1756: 'Minimum Basic Pay',p_effective_date);
1757: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1758: p_retained_pay_plan||'-'|| p_retained_grade,

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

1753: else
1754: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1755: p_retained_pay_plan ||'-'|| p_retained_grade,
1756: 'Minimum Basic Pay',p_effective_date);
1757: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1758: p_retained_pay_plan||'-'|| p_retained_grade,
1759: 'Maximum Basic Pay',p_effective_date);
1760: end if;
1761: if max_basic_pay IS NOT NULL then

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

1772: if substr(p_retained_pay_plan,1,1) = 'W' or p_retained_pay_plan in ('XF','XG','XH','XE') then
1773: if substr(p_retained_pay_plan,1,1) = 'W' and
1774: p_retained_pay_plan not in ('WG','WL','WM','WS') then
1775: min_basic_pay := 0; -- no check in table
1776: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1777: substr(p_retained_pay_plan,1,1),
1778: 'Maximum Basic Pay',p_effective_date);
1779: elsif p_retained_pay_plan = 'XE' then
1780: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

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

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

1779: elsif p_retained_pay_plan = 'XE' then
1780: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1781: p_retained_pay_plan,
1782: 'Minimum Basic Pay',p_effective_date);
1783: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1784: p_retained_pay_plan,
1785: 'Maximum Basic Pay',p_effective_date);
1786: else
1787: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

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

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

1786: else
1787: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1788: p_retained_pay_plan ||'-'|| p_retained_grade,
1789: 'Minimum Basic Pay',p_effective_date);
1790: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
1791: p_retained_pay_plan||'-'|| p_retained_grade,
1792: 'Maximum Basic Pay',p_effective_date);
1793: end if;
1794: if max_basic_pay IS NOT NULL then

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

1815: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1816: if p_to_pay_plan = 'VM'
1817: and p_rate_determinant_code = '0' then
1818:
1819: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1820: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1821: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1822: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1823:

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

1817: and p_rate_determinant_code = '0' then
1818:
1819: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1820: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1821: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 12',
1822: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1823:
1824: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1825: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

1844:
1845: /*if p_to_pay_plan = 'VP'
1846: and p_rate_determinant_code = '0' then
1847:
1848: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1849: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1850: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1851: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1852:

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

1846: and p_rate_determinant_code = '0' then
1847:
1848: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1849: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1850: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 13',
1851: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1852:
1853: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and
1854: (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

1869: Default: Insert asterisks in pay basis and basic pay.
1870: if p_to_pay_plan = 'VN'
1871: and p_rate_determinant_code = '0' then
1872:
1873: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1874: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1875: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1876: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1877:

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

1871: and p_rate_determinant_code = '0' then
1872:
1873: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1874: p_to_grade_or_level, 'Minimum Basic Pay',p_effective_date);
1875: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 14',
1876: p_to_grade_or_level, 'Maximum Basic Pay',p_effective_date);
1877:
1878: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1879: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

1900: if p_to_pay_plan = 'SR' and
1901: substr(p_agency_subelement,1,2) = 'VA' and
1902: p_rate_determinant_code = '0' then
1903:
1904: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1905: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1906: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1907: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1908:

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

1902: p_rate_determinant_code = '0' then
1903:
1904: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1905: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1906: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
1907: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1908:
1909: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1910: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

1929: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1930: if p_to_pay_plan = 'NC' then
1931: if p_rate_determinant_code in ('0','7') then
1932:
1933: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1934: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1935: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1936: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1937:

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

1931: if p_rate_determinant_code in ('0','7') then
1932:
1933: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1934: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1935: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1936: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1937:
1938: elsif p_rate_determinant_code in ('5','6') then
1939: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',

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

1935: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 44',
1936: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1937:
1938: elsif p_rate_determinant_code in ('5','6') then
1939: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1940: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1941: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1942: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1943: end if;

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

1937:
1938: elsif p_rate_determinant_code in ('5','6') then
1939: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1940: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1941: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 45',
1942: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1943: end if;
1944: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1945: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

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

1965: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1966: if p_to_pay_plan = 'NO' then
1967: if p_rate_determinant_code in ('0','7') then
1968:
1969: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1970: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1971: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1972: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1973:

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

1967: if p_rate_determinant_code in ('0','7') then
1968:
1969: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1970: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1971: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1972: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1973:
1974: elsif p_rate_determinant_code in ('5','6') then
1975: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',

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

1971: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 46',
1972: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1973:
1974: elsif p_rate_determinant_code in ('5','6') then
1975: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1976: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1977: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1978: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1979: end if;

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

1973:
1974: elsif p_rate_determinant_code in ('5','6') then
1975: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1976: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
1977: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 47',
1978: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
1979: end if;
1980: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
1981: 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 48',

2002: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
2003: if p_to_pay_plan = 'NP' 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 48',
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 48',
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 48',

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 48',
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 48',
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 49',

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

2008: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 48',
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 49',
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 49',
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 49',

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 49',
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 49',
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 50',

2038: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
2039: if p_to_pay_plan = 'NR' 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 50',
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 50',
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 50',

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 50',
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 50',
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 51',

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

2044: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 50',
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 51',
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 51',
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 51',

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 51',
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 51',
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 2076: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

2072: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
2073: -------------------------------------------------------------------------------
2074: IF p_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
2075: if p_to_pay_plan = 'KA' then
2076: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
2077: p_to_pay_plan ,
2078: 'Minimum Basic Pay',p_effective_date);
2079:
2080: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',

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

2076: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
2077: p_to_pay_plan ,
2078: 'Minimum Basic Pay',p_effective_date);
2079:
2080: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
2081: p_to_pay_plan ,
2082: 'Maximum Basic Pay',p_effective_date);
2083:
2084: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL then

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

2108: if p_agency_subelement = 'DD16' and
2109: p_to_pay_plan in ('AD', 'TP') and
2110: p_to_pay_basis in ('PD','SY') then
2111:
2112: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
2113: p_to_pay_plan ,
2114: 'Minimum Basic Pay',
2115: p_effective_date);
2116: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',

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

2112: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
2113: p_to_pay_plan ,
2114: 'Minimum Basic Pay',
2115: p_effective_date);
2116: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 24',
2117: p_to_pay_plan ,
2118: 'Maximum Basic Pay',
2119: p_effective_date);
2120: if max_basic_pay IS NOT NULL and

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

2131: if p_agency_subelement = 'DD16' and
2132: p_to_pay_plan in ('AD', 'TP') and
2133: p_to_pay_basis in ('PD','SY') then
2134:
2135: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',
2136: p_to_pay_plan ,
2137: 'Minimum Basic Pay',
2138: p_effective_date);
2139: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',

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

2135: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',
2136: p_to_pay_plan ,
2137: 'Minimum Basic Pay',
2138: p_effective_date);
2139: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 54',
2140: p_to_pay_plan ,
2141: 'Maximum Basic Pay',
2142: p_effective_date);
2143: if max_basic_pay IS NOT NULL and

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

2169: and p_retained_pay_plan in ('GS','GG')
2170: and p_retained_step between '01' and '10'
2171: and p_rate_determinant_code in ('E','F','M') then
2172:
2173: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
2174: p_retained_grade,
2175: 'Maximum Basic Pay',p_effective_date);
2176:
2177: if max_basic_pay IS NOT NULL and

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

2200: if not(p_to_pay_plan in ('GH','GM'))
2201: and p_retained_pay_plan in ('GH','GM')
2202: and p_rate_determinant_code in ('A','B') then
2203:
2204: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2205: p_retained_grade ||'-'|| p_retained_step,
2206: 'Minimum Basic Pay',p_effective_date);
2207: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2208: p_retained_grade ||'-'|| p_retained_step,

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

2203:
2204: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2205: p_retained_grade ||'-'|| p_retained_step,
2206: 'Minimum Basic Pay',p_effective_date);
2207: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
2208: p_retained_grade ||'-'|| p_retained_step,
2209: 'Maximum Basic Pay',p_effective_date);
2210:
2211: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL and

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

2233:
2234: if p_to_pay_plan = 'GS'
2235: and p_rate_determinant_code in ('5','6','M') then
2236:
2237: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
2238: p_to_grade_or_level,
2239: 'Maximum Basic Pay',p_effective_date);
2240:
2241: if max_basic_pay IS NOT NULL

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

2262: if not(p_to_pay_plan in ('GM','GH'))
2263: and p_retained_pay_plan in ('GM','GH')
2264: and p_rate_determinant_code in ('E','F','M') then
2265:
2266: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2267: p_retained_grade,
2268: 'Minimum Basic Pay',p_effective_date);
2269:
2270: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',

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

2266: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2267: p_retained_grade,
2268: 'Minimum Basic Pay',p_effective_date);
2269:
2270: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2271: p_retained_grade,
2272: 'Maximum Basic Pay',p_effective_date);
2273:
2274: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2297: and p_retained_pay_plan in ('GS','GG')
2298: and p_rate_determinant_code in ('E','F','M')
2299: and p_retained_step between '01' and '10' then
2300:
2301: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 19',
2302: p_retained_grade,
2303: 'Maximum Basic Pay',p_effective_date);
2304:
2305: if max_basic_pay IS NOT NULL

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

2326: if p_to_pay_plan in ('GM','GH')
2327: and p_retained_pay_plan in ('GM','GH')
2328: and p_rate_determinant_code in ('E','F','M') then
2329:
2330: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2331: p_retained_grade,
2332: 'Minimum Basic Pay',p_effective_date);
2333: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2334: p_retained_grade,

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

2329:
2330: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2331: p_retained_grade,
2332: 'Minimum Basic Pay',p_effective_date);
2333: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 20',
2334: p_retained_grade,
2335: 'Maximum Basic Pay',p_effective_date);
2336:
2337: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2357:
2358: if p_to_pay_plan = 'AL'
2359: and p_rate_determinant_code <> 'C' then
2360: if p_to_grade_or_level in ('01', '02') then
2361: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
2362: p_to_grade_or_level,
2363: 'Maximum Basic Pay',
2364: p_effective_date);
2365: else

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

2362: p_to_grade_or_level,
2363: 'Maximum Basic Pay',
2364: p_effective_date);
2365: else
2366: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 22',
2367: p_to_grade_or_level || '-' ||p_to_step_or_rate,
2368: 'Maximum Basic Pay',
2369: p_effective_date);
2370: end if;

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

2388: Basis for Edit: 5 U.S.C. 5372a*/
2389: if p_to_pay_plan = 'CA'
2390: and p_rate_determinant_code <> 'C' then
2391:
2392: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 23',
2393: p_to_grade_or_level,
2394: 'Minimum Basic Pay',p_effective_date);
2395:
2396: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2414:
2415: if p_to_pay_plan in ('ST', 'SL')
2416: and p_rate_determinant_code <> 'C' then
2417:
2418: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2419: p_to_pay_plan ,
2420: 'Minimum Basic Pay',p_effective_date);
2421:
2422: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',

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

2418: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2419: p_to_pay_plan ,
2420: 'Minimum Basic Pay',p_effective_date);
2421:
2422: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
2423: p_to_pay_plan ,
2424: 'Maximum Basic Pay',p_effective_date);
2425:
2426: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2442:
2443: if p_to_pay_plan = 'IJ' and
2444: p_rate_determinant_code in ('0','7') then
2445:
2446: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 36',
2447: p_to_step_or_rate ,
2448: 'Maximum Basic Pay',
2449: p_effective_date);
2450: if max_basic_pay IS NOT NULL and

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

2465: Default: Insert asterisks in pay basis and basic pay.*/
2466: if p_to_pay_plan in ('AF','FO','FP')
2467: and p_rate_determinant_code <> 'C' then
2468:
2469: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
2470: p_to_grade_or_level || '-' || p_to_step_or_rate,
2471: 'Minimum Basic Pay',p_effective_date);
2472:
2473: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',

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

2469: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
2470: p_to_grade_or_level || '-' || p_to_step_or_rate,
2471: 'Minimum Basic Pay',p_effective_date);
2472:
2473: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 10',
2474: p_to_grade_or_level || '-' || p_to_step_or_rate,
2475: 'Maximum Basic Pay',p_effective_date);
2476:
2477: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL

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

2498: p_rate_determinant_code not in ('A','B','E','F','U','V') then
2499: max_basic_pay := NULL;
2500: min_basic_pay := NULL;
2501: if substr(p_to_pay_plan,1,1) = 'W' and p_to_pay_plan not in ('WG','WL','WM','WS') then
2502: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2503: substr(p_to_pay_plan,1,1),
2504: 'Minimum Basic Pay',p_effective_date);
2505: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2506: substr(p_to_pay_plan,1,1),

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

2501: if substr(p_to_pay_plan,1,1) = 'W' and p_to_pay_plan not in ('WG','WL','WM','WS') then
2502: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2503: substr(p_to_pay_plan,1,1),
2504: 'Minimum Basic Pay',p_effective_date);
2505: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2506: substr(p_to_pay_plan,1,1),
2507: 'Maximum Basic Pay',p_effective_date);
2508: elsif p_to_pay_plan = 'XE' then
2509: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

2505: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2506: substr(p_to_pay_plan,1,1),
2507: 'Maximum Basic Pay',p_effective_date);
2508: elsif p_to_pay_plan = 'XE' then
2509: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2510: p_to_pay_plan,
2511: 'Minimum Basic Pay',p_effective_date);
2512: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2513: p_to_pay_plan,

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

2508: elsif p_to_pay_plan = 'XE' then
2509: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2510: p_to_pay_plan,
2511: 'Minimum Basic Pay',p_effective_date);
2512: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2513: p_to_pay_plan,
2514: 'Maximum Basic Pay',p_effective_date);
2515: else
2516: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',

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

2512: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2513: p_to_pay_plan,
2514: 'Maximum Basic Pay',p_effective_date);
2515: else
2516: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2517: p_to_pay_plan ||'-'|| p_to_grade_or_level,
2518: 'Minimum Basic Pay',p_effective_date);
2519: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 11',
2520: p_to_pay_plan ||'-'|| p_to_grade_or_level,

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

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

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

2545: if p_to_pay_plan = 'SR' and
2546: substr(p_agency_subelement,1,2) = 'VA' and
2547: p_rate_determinant_code <> 'C' then
2548:
2549: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2550: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2551: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2552: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2553:

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

2547: p_rate_determinant_code <> 'C' then
2548:
2549: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2550: p_to_pay_plan , 'Minimum Basic Pay',p_effective_date);
2551: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 16',
2552: p_to_pay_plan , 'Maximum Basic Pay',p_effective_date);
2553:
2554: if min_basic_pay IS NOT NULL and max_basic_pay IS NOT NULL
2555: and (not(to_number(p_to_basic_pay) between nvl(min_basic_pay,0) and nvl(max_basic_pay,0))

Line 2565: end ghr_cpdf_check8;

2561: end if;
2562: end if;
2563: hr_utility.set_location('Leaving CPDF 8 ',1);
2564: end basic_pay;
2565: end ghr_cpdf_check8;