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 FND_DATE

Line 124: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and

120: -- 8 05/14/99 vravikan 10/01/98 New Edit
121: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
122: /* If Pay plan is JA
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);

Line 125: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

121: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
122: /* If Pay plan is JA
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',

Line 149: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

145: Then basic pay must match the entry for grade and step
146: or rate on Table 1 or be asterisks.
147: Default: Insert asterisks in pay basis and basic pay. */
148: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
149: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
150: if (
151: p_to_pay_plan = 'FG' and
152: (p_rate_determinant_code = '0' or
153: p_rate_determinant_code = '7')

Line 220: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

216: /* If Pay plan is VE
217: And pay rate determinant is 0,
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',

Line 450: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

446: And pay rate determinant is 0,
447: And occupation is 0605 or 0610
448: then basic pay must be within the range on Table 15 */
449: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
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',

Line 477: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN

473: -- Update/Change Date By Effective Date Bug Comment
474: -- 10/2 08/13/99 vravikan 992944 Change step 1 to step 10
475: -- upd52 13-Feb-07 Raju From 01-Sep-2004 Bug#5745356 terminate
476:
477: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN
478: if (( p_first_action_noa_la_code1 = 'J8M' or
479: p_first_action_noa_la_code2 = 'J8M') and
480: (p_first_noac_lookup_code in ('170','570') and
481: substr(p_to_pay_plan,1,1) in ('W','X'))) then

Line 723: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and

719: Table 37 or Table 38(depending on pay rate determinant) or
720: be asterisks.
721: Default: Insert asterisks in pay basis and basic pay.
722:
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',

Line 758: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

754: be asterisks.
755:
756: Default: Insert asterisks in pay basis and basic pay.*/
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 ,

Line 786: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

782: on Table 27 or be asterisks.
783:
784: Default: Insert asterisks in pay basis and basic pay.*/
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 ,

Line 815: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and

811: Table 39 or Table 40(depending on pay rate determinant) or
812: be asterisks.
813: Default: Insert asterisks in pay basis and basic pay.
814:
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',

Line 851: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and

847: Table 41 or Table 42(depending on pay rate determinant) or
848: be asterisks.
849: Default: Insert asterisks in pay basis and basic pay.
850:
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',

Line 1027: IF p_effective_date >= fnd_date.canonical_to_date('2007/08/13') THEN

1023: step on Table 57 or be asterisks.
1024: Table 57 is '0491'
1025: */
1026: -- 650.21.1 and 650.21.2
1027: IF p_effective_date >= fnd_date.canonical_to_date('2007/08/13') THEN
1028: if (
1029: p_to_pay_plan = 'GL' and
1030: (p_rate_determinant_code = '0' or p_rate_determinant_code = '7')
1031: ) then

Line 1199: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1195: /*650.28.3 If pay plan is FT,
1196: Then basic pay must be within the range on Table 21 or
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',

Line 1263: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1259: Default: Insert asterisks in pay basis and basic pay.*/
1260:
1261: -- 17-Aug-00 vravikan 01-jan-2000 Delete step or rate
1262: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
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',

Line 1426: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN

1422: -- And step is 13 or 14,
1423: -- Then basic pay must equal entry for the step on Table 7 or be asterisks.
1424: -- 19-MAR-2003 vnarasim First version of the edit
1425: -- upd52 13-Feb-07 Raju From 01-Sep-2004 Bug#5745356 terminate
1426: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN
1427: if p_to_pay_plan = 'FA'
1428: and p_agency_subelement = 'ST'
1429: and p_rate_determinant_code = '0'
1430: and p_to_step_or_rate in ('13','14') then

Line 1462: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN

1458: -- to And grade is 13 or 14
1459: -- 19-MAR-2003 NarasimhaRao Changed the parameter from p_to_grade_or_level to
1460: -- p_to_step_or _rate
1461: -- upd52 13-Feb-07 Raju From 01-Sep-2004 Bug#5745356 terminate
1462: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN
1463: if p_to_pay_plan = 'FA'
1464: and p_agency_subelement = 'ST'
1465: and p_rate_determinant_code = '0'
1466: and p_to_grade_or_level in ('13','14') then

Line 1580: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1576: -- 20/2 27-Feb-2003 Madhuri Modified the requirement
1577: -- from Then Basic Pay must equal the entry for the grade on Table 8 or be asterisks.
1578: -- to Then Basic Pay must be within the range for the grade on Table 8 or be asterisks.
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,

Line 1816: if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then

1812: /*
1813: --
1814: -- Commented the edit for bug 557188 on 7-aug-98
1815: --
1816: if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
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

Line 1886: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

1882: Then basic pay must fall within the range for the grade
1883: on Table 12 or be asterisks.
1884:
1885: Default: Insert asterisks in pay basis and basic pay.*/
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',

Line 1972: if p_effective_date < fnd_date.canonical_to_date('2007/06/07') then

1968:
1969: Basis for Edit: E.O.12496*/
1970:
1971: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 06-Jun-2007
1972: if p_effective_date < fnd_date.canonical_to_date('2007/06/07') then
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:

Line 2002: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

1998: (depending on pay rate determinant) or be asterisks.
1999: If pay rate determinant is 0 or 7 then compare to table 44.
2000: If pay rate determinant is 5 or 6 then compare to table 45.
2001:
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',

Line 2038: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

2034: (depending on pay rate determinant) or be asterisks.
2035: If pay rate determinant is 0 or 7 then compare to table 46.
2036: If pay rate determinant is 5 or 6 then compare to table 47.
2037:
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',

Line 2075: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

2071: (depending on pay rate determinant) or be asterisks.
2072: If pay rate determinant is 0 or 7 then compare to table 48.
2073: If pay rate determinant is 5 or 6 then compare to table 49.
2074:
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',

Line 2111: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

2107: Then basic pay must be within the range for the grade on Table 50 or Table 51
2108: (depending on pay rate determinant) or be asterisks.
2109: If pay rate determinant is 0 or 7 then compare to table 50.
2110: If pay rate determinant is 5 or 6 then compare to table 51.
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',

Line 2147: IF p_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN

2143: -- Modified by Date Comments
2144: -------------------------------------------------------------------------------
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);

Line 2180: if p_effective_date <= fnd_date.canonical_to_date('20'||'02/08/31') then

2176: -- 16-Oct-2002 vnarasim 01-JUN-2002 New Edit
2177: -- 28-Nov-2002 Madhuri If effective Date<=31stJul2002 looks
2178: -- into CPDF Edit Table 24 else into CPDF Table 54
2179: /* Commented the edit for bug#2956013 on 13-Oct-2003.
2180: if p_effective_date <= fnd_date.canonical_to_date('20'||'02/08/31') then
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:

Line 2489: if p_effective_date < fnd_date.canonical_to_date('2008/10/14') then

2485:
2486: Basis for Edit: 5 U.S.C. 5376*/
2487: -- Upd57 30-Jul-09 Mani Bug # 8653515 14-OCT-2008 Added PRD D in the condition
2488:
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',

Line 2543: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2539: rate on Table 36 or be asterisks.
2540:
2541: Default: Insert asterisks in pay basis and basic pay. */
2542: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
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',

Line 2568: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2564: on Table 10 or be asterisks.
2565:
2566: Default: Insert asterisks in pay basis and basic pay.*/
2567: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
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',

Line 2649: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

2645: rate, pay basis, and basic pay.
2646:
2647: Basis for Edit: E.O. 12496*/
2648: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2649: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
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: