eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_CHECK7 dependencies on FND_DATE

Line 97: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then

93: -- 840-848,878-879. Add 890
94: -- upd53 20-Apr-07 Raju From 01-Jan-2007 Bug#5996938 added 815-817, 825
95: -- 827,840-849,878-879.
96:
97: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then
98: if (
99: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and
100: p_first_noac_lookup_code not in
101: ( '702','703','713','721','740','741','815','816','817','825','840','841',

Line 117: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then

113: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
114: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');
115: hr_utility.raise_error;
116: end if;
117: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
118: if (
119: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and
120: p_first_noac_lookup_code not in
121: ( '702','703','713','721','740','741','815','816','817','825','840','841',

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

203: for the prior grade on Table 37 or Table 38
204: (depending on prior pay rate determinant) or be asterisks.
205: Default: Insert asterisks in pay basis and basic pay.
206:
207: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
208: p_prior_pay_plan = 'NH' and
209: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
210: if p_prior_pay_rate_det_code in ('0','7') then
211: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',

Line 245: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then

241:
242: Default: Insert asterisks in prior pay basis and prior
243: basic pay.*/
244: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
245: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
246: if p_prior_pay_plan = 'GS' and
247: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
248:
249: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',

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

267: for the prior grade on Table 39 or Table 40
268: (depending on prior pay rate determinant) or be asterisks.
269: Default: Insert asterisks in pay basis and basic pay.
270:
271: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
272: p_prior_pay_plan = 'NJ' and
273: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
274: if p_prior_pay_rate_det_code in ('0','7') then
275: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',

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

303: for the prior grade on Table 41 or Table 42
304: (depending on pay rate determinant) or be asterisks.
305: Default: Insert asterisks in pay basis and basic pay.
306:
307: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
308: p_prior_pay_plan = 'NK' and
309: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
310: if p_prior_pay_rate_det_code in ('0','7') then
311: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',

Line 405: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then

401: Default: Insert asterisks in prior pay basis and prior
402: basic pay.*/
403: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan GS
404:
405: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
406: if p_prior_pay_plan in ('GH', 'GM') and
407: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
408: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
409: p_prior_grade_or_level || '-' || p_prior_step_or_rate,

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

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

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

996: is 0 or 7 then compare to table 44. If prior pay rate determinant is 5 or 6
997: then compare to table 45.
998:
999:
1000: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1001: if p_prior_pay_plan = 'NC' then
1002: if p_prior_pay_rate_det_code in ('0','7')
1003: then
1004:

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

1039: Table 46 or Table 47 (depending on prior pay rate determinant).
1040: If prior pay rate determinant is 0 or 7 then compare to table 46.
1041: If prior pay rate determinant is 5 or 6 then compare to table 47.
1042:
1043: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1044: if p_prior_pay_plan = 'NO' then
1045: if p_prior_pay_rate_det_code in ('0','7')
1046: then
1047:

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

1081: or Table 49 (depending on prior pay rate determinant).
1082: If prior pay rate determinant is 0 or 7 then compare to table 48.
1083: If prior pay rate determinant is 5 or 6 then compare to table 49.
1084:
1085: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1086: if p_prior_pay_plan = 'NP' then
1087: if p_prior_pay_rate_det_code in ('0','7')
1088: then
1089:

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

1125: If prior pay rate determinant is 0 or 7 then compare to table 50.
1126: If prior pay rate determinant is 5 or 6 then compare to table 51.
1127:
1128:
1129: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1130: if p_prior_pay_plan = 'NR' then
1131: if p_prior_pay_rate_det_code in ('0','7')
1132: then
1133:

Line 1829: IF p_effective_date < fnd_date.canonical_to_date('1998/03/01') then

1825: --- To:'And locality pay area is other than ZY or ZZ' as of 09-JAN-2005
1826: -- Raju 31/1/06 Commented the code effective from 01-May-2005
1827: -- upd50 06-Feb-07 Raju From 01-Oct-2006 Bug#5745356
1828: -------------------------------------------------------------------------------
1829: IF p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
1830: if (
1831: p_to_pay_plan in ('GS','GM','GG','GH') and
1832: p_pay_rate_determinant_code in ('6','5','M') and
1833: p_locality_pay_area between '02' and '88' and

Line 2000: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then

1996: -- Raju 26-Jun-06 Validate for actions after 01-Jan-2006
1997: -- and added pay plan condition affective frm 01-Apr-06
1998: -- arbasu 26-Oct-06 Added PRD condition for GHR_38932_ALL_PROCEDURE_FAIL
1999: -------------------------------------------------------------------------------
2000: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
2001: if (p_locality_pay_area = '99' and
2002: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2003: GHR_GHRWS52L.CPDF_Parameter_Check;
2004: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');

Line 2036: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then

2032: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');
2033: hr_utility.raise_error;
2034: end if;
2035: -- Begin Bug# 5073313
2036: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2037: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and
2038: p_pay_rate_determinant_code NOT in ('6','5','E','F')
2039: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2040: then

Line 2073: /* if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then

2069: -- than CA or MX,
2070: -- Or pay plan is FO or FP,
2071: -- Then locality adjustment must be spaces or asterisks.
2072:
2073: /* if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
2074: if p_locality_pay_area = '99' and
2075: substr(p_agency_subelement,1,2) in ('AM','GY','HS','IB','ST') and
2076: (
2077: substr(p_duty_station_code,1,2) not in ('CA','MX') or

Line 2372: p_effective_date >= fnd_date.canonical_to_date('1994/01/01')) and

2368: -- 652.95.2
2369: if ((p_to_pay_plan in ('GS','GM','GG','GH','FO','FP','FE','ES','ST','AL','CA','SL') and
2370: p_locality_pay_area <> '99' and
2371: p_pay_rate_determinant_code not in ('A','B','C','E','F','U','V') and
2372: p_effective_date >= fnd_date.canonical_to_date('1994/01/01')) and
2373: (
2374: substr(p_first_noac_lookup_code,1,1) <> '3' and
2375: substr(p_first_noac_lookup_code,1,1) <> '4'
2376: )

Line 2652: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN

2648: --- Madhuri 01-MAR-05 Change the condition 'If prior locality pay area is 99'
2649: --- To:'If prior locality pay area is ZZ' as of 09-JAN-05
2650: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added prior pay plan condition
2651: -------------------------------------------------------------------------------
2652: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN
2653: if (p_prior_locality_pay_area = '99' and
2654: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2655: GHR_GHRWS52L.CPDF_Parameter_Check;
2656: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');

Line 2686: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then

2682: GHR_GHRWS52L.CPDF_Parameter_Check;
2683: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2684: hr_utility.raise_error;
2685: end if;
2686: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2687: if p_prior_locality_pay_area = 'ZZ' and
2688: p_prior_pay_rate_det_code not in ('5','6','E','F') and
2689: p_prior_locality_adj is not null and
2690: to_number(p_prior_locality_adj) <> 0

Line 2725: /* if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then

2721: -- than CA or MX,
2722: -- Or prior pay plan is FO or FP,
2723: -- Then prior locality adjustment must be spaces or asterisks.
2724:
2725: /* if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
2726: if p_prior_locality_pay_area = '99' and
2727: substr(p_agency_subelement,1,2) in ('AM','GY','HS','IB','ST') and
2728: (
2729: substr(p_prior_duty_station,1,2) not in ('CA','MX') or