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.

[Home] [Help]

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 219: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313

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

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

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

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

715: Table 37 or Table 38(depending on pay rate determinant) or
716: be asterisks.
717: Default: Insert asterisks in pay basis and basic pay.
718:
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',

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

802: Table 39 or Table 40(depending on pay rate determinant) or
803: be asterisks.
804: Default: Insert asterisks in pay basis and basic pay.
805:
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',

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

838: Table 41 or Table 42(depending on pay rate determinant) or
839: be asterisks.
840: Default: Insert asterisks in pay basis and basic pay.
841:
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',

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

1353: -- And step is 13 or 14,
1354: -- Then basic pay must equal entry for the step on Table 7 or be asterisks.
1355: -- 19-MAR-2003 vnarasim First version of the edit
1356: -- upd52 13-Feb-07 Raju From 01-Sep-2004 Bug#5745356 terminate
1357: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN
1358: if p_to_pay_plan = 'FA'
1359: and p_agency_subelement = 'ST'
1360: and p_rate_determinant_code = '0'
1361: and p_to_step_or_rate in ('13','14') then

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

1389: -- to And grade is 13 or 14
1390: -- 19-MAR-2003 NarasimhaRao Changed the parameter from p_to_grade_or_level to
1391: -- p_to_step_or _rate
1392: -- upd52 13-Feb-07 Raju From 01-Sep-2004 Bug#5745356 terminate
1393: if p_effective_date < fnd_date.canonical_to_date('2004/09/01') THEN
1394: if p_to_pay_plan = 'FA'
1395: and p_agency_subelement = 'ST'
1396: and p_rate_determinant_code = '0'
1397: and p_to_grade_or_level in ('13','14') then

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

1741: /*
1742: --
1743: -- Commented the edit for bug 557188 on 7-aug-98
1744: --
1745: if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
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

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

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

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

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

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

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

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 48.
2000: If pay rate determinant is 5 or 6 then compare to table 49.
2001:
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',

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

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

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

2070: -- Modified by Date Comments
2071: -------------------------------------------------------------------------------
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);

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

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