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_CHECK4A dependencies on FND_DATE

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

50: --300.16.2
51: -- added 'Z2U' on 22-jul-1998
52: -- Update/Change Date By Effective Date Comment
53: -- 10/2 08/13/99 vravikan 01-Aug-1999 Change R5M to R6M
54: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/08/01') then
55: if p_First_NOAC_Lookup_Code= '312'
56: and
57: NOT ( p_First_Action_NOA_LA_Code1 in
58: ('RPM','RPR','RQM','RRM','RSM','RTM','RTR','RUM','RWM',

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

80: --300.19.2
81: -- Update/Change Date By Effective Date Comment
82: -- 10/2 08/13/99 vravikan 01-Aug-1999 Change R5M to R6M
83: -- 30/12/08 Raju Added UFM, removed R7M,R8M,R9M
84: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/08/01') then
85: if p_First_NOAC_Lookup_Code= '317'
86: and
87: NOT ( p_First_Action_NOA_LA_Code1 in
88: ('RPM','RQM','RRM','RSM','RUM','R6M','UFM','V8V','ZVB','ZVC') AND

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

217:
218: --315.02.2
219: -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
220: -- added 'Z2U' on 22-jul-1998
221: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
222: if p_First_NOAC_Lookup_Code= '385'
223: and
224: NOT ( p_First_Action_NOA_LA_Code1 in
225: ( 'HAM','L2M','L4M','L5M','L6M','L8M','LXM','UFM','VGL',

Line 296: if p_effective_date < fnd_date.canonical_to_date('19'||'99/01/01') then

292:
293: --320.14.2
294: -- Update Date By Effective Date Comment
295: -- 8 01/28/99 vravikan 01/01/99 End date
296: if p_effective_date < fnd_date.canonical_to_date('19'||'99/01/01') then
297: if p_First_NOAC_Lookup_Code= '462'
298: and
299: NOT ( p_First_Action_NOA_LA_Code1 in
300: ( 'GFM','R4M','UFM','V8V','ZVB') AND

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

375: --320.26.2
376: -- 10/4 08/13/99 vravikan 01-Jan-99 Add VGL
377:
378: -- added legal authority Z2W on 9-oct-98
379: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
380: if p_First_NOAC_Lookup_Code= '480'
381: and
382: NOT ( p_First_Action_NOA_LA_Code1 in
383: ('UFM','V3M','VGL','Z2W','ZSP','ZVB','ZVC') AND

Line 432: if p_effective_date < fnd_date.canonical_to_date('2005/02/01') then --Bug#5619873

428: -- GPPA U60 22-Nov-12 Raju 10-Jul-12 Added LA Codes LAT, bug# 15853224
429: -- GPPA U60 05-Feb-13 Raju 06-Jan-13 removed LA Codes LAR,LAS,LAT, bug# 16217492
430:
431: if p_effective_date >= to_date('19'||'99/12/01','yyyy/mm/dd') then
432: if p_effective_date < fnd_date.canonical_to_date('2005/02/01') then --Bug#5619873
433: if p_First_NOAC_Lookup_Code= '500' and
434: NOT ( p_First_Action_NOA_LA_Code1 in
435: ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
436: 'BAB','BAC','BAD','BAE','BYO',

Line 460: elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then --Begin Bug#5619873

456: 'ZRM','ZSK','ZSP','ZTR','ZTU','ZTZ','ZVB','Z5B','Z5C','Z5D','Z5E') ) THEN
457: hr_utility.set_message(8301, 'GHR_37299_ALL_PROCEDURE_FAIL');
458: hr_utility.raise_error;
459: end if;
460: elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then --Begin Bug#5619873
461: if p_First_NOAC_Lookup_Code= '500' and
462: NOT ( p_First_Action_NOA_LA_Code1 in
463: ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
464: 'BAB','BAC','BAD','BAE','BYO',

Line 495: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then

491: hr_utility.raise_error;
492: end if;
493: --End Bug#5619873
494: --Bug# 8329793
495: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then
496: if p_First_NOAC_Lookup_Code= '500' and
497: NOT ( p_First_Action_NOA_LA_Code1 in
498: ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
499: 'BAB','BAC','BAD','BAE','BAG','BYO',

Line 528: elsif p_effective_date < fnd_date.canonical_to_date('2012/07/09') then

524: VGL, Z2U, Z2W, ZBA, ZGM, ZGY, ZHK, ZJK, ZJM, ZLM, ZMM, ZQM, ZRM, ZSK, ZSP, ZTR, ZTU, ZTZ, ZVB, Z5B, Z5C,
525: Z5D, Z5E.');
526: hr_utility.raise_error;
527: end if;
528: elsif p_effective_date < fnd_date.canonical_to_date('2012/07/09') then
529: if p_First_NOAC_Lookup_Code= '500' and
530: NOT ( p_First_Action_NOA_LA_Code1 in
531: ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
532: 'BAB','BAC','BAD','BAE','BAG','BYO',

Line 562: elsif p_effective_date <= fnd_date.canonical_to_date('2013/01/06') then

558: hr_utility.raise_error;
559: end if;
560: --BUG # 14395108, 14686025
561: --Bug# 16217492
562: elsif p_effective_date <= fnd_date.canonical_to_date('2013/01/06') then
563: if p_First_NOAC_Lookup_Code= '500' and
564: NOT ( p_First_Action_NOA_LA_Code1 in
565: ('ABK','ABL','ABM','ACA','ACM','AYM','A2M',
566: 'BAB','BAC','BAD','BAE','BAG','BYO',

Line 1093: if p_effective_date >= fnd_date.canonical_to_date('2009/02/17') then

1089: -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM
1090: --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1091: --- Upd 57 30-Jul-09 Mani 01-Jan-2009 Added LA code BAG
1092:
1093: if p_effective_date >= fnd_date.canonical_to_date('2009/02/17') then
1094: if p_First_NOAC_Lookup_Code= '507'
1095: and
1096: NOT ( p_First_Action_NOA_LA_Code1 in
1097: ('ABL','ABM','ABR','ABS','AYM','BAG','BWA','BWM',

Line 1108: elsif p_effective_date >= fnd_date.canonical_to_date('2009/01/01') then

1104: hr_utility.set_message(8301, 'GHR_37052_ALL_PROCEDURE_FAIL');
1105: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BAG, BWM, BWA, HAM, HDM, HGM, HJM, HLM, NUM, PNR, V1P, V8N, Z2U, ZEA, ZLM, ZRM, ZSK.');
1106: hr_utility.raise_error;
1107: end if;
1108: elsif p_effective_date >= fnd_date.canonical_to_date('2009/01/01') then
1109: if p_First_NOAC_Lookup_Code= '507'
1110: and
1111: NOT ( p_First_Action_NOA_LA_Code1 in
1112: ('ABL','ABM','ABR','ABS','AYM','BAG','BWA','BWM',

Line 1123: elsif p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then

1119: hr_utility.set_message(8301, 'GHR_37052_ALL_PROCEDURE_FAIL');
1120: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, BAG, BWM, BWA, HAM, HDM, HGM, HJM, HLM, NUM, PNR, V1P, V8N, Z2U, BAG, ZLM, ZRM, ZSK.');
1121: hr_utility.raise_error;
1122: end if;
1123: elsif p_effective_date >= fnd_date.canonical_to_date('19'||'99/02/27') then
1124: if p_First_NOAC_Lookup_Code= '507'
1125: and
1126: NOT ( p_First_Action_NOA_LA_Code1 in
1127: ('ABL','ABM','ABR','ABS','AYM','BWA','BWM',

Line 1436: IF p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then

1432: -- 14-SEP-2004 Madhuri
1433: -------------------------------------------------------------------------------------
1434: IF ( p_effective_date <= to_date('20'||'04/08/31','yyyy/mm/dd') ) THEN
1435:
1436: IF p_effective_date >= fnd_date.canonical_to_date('19'||'99/01/01') then
1437: if p_First_NOAC_Lookup_Code= '512'
1438: and
1439: NOT ( p_First_Action_NOA_LA_Code1 in
1440: ('ABL','ABM','AYM','BWM','HAM',

Line 2948: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then

2944: --329.30.2
2945: -- Update Date By Effective Date Comment
2946: -- 05-NOV-03 ajose From the begining Added the Edit as a part of EOY03 changes
2947: --upd47 26-Jun-06 Raju From 01-May-2006 Terminate the edit
2948: if p_effective_date < fnd_date.canonical_to_date('2006/05/01') then
2949: IF p_First_NOAC_Lookup_Code= '849' AND
2950: NOT ( p_First_Action_NOA_LA_Code1 IN
2951: ('V9N','V9P') AND
2952: p_First_Action_NOA_LA_Code2 IN