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

Line 168: if p_effective_date < fnd_date.canonical_to_date('2007/10/25') then

164: end if;
165:
166: -- 600.10.3
167: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 24-Oct-2007
168: if p_effective_date < fnd_date.canonical_to_date('2007/10/25') then
169: if substr(p_duty_station_lookup_code, 1, 2) = '15' and
170: p_race_or_natnl_origin not in ('A','C','D','E','F','G','H','I','J',
171: 'K','L','M','N','O','P','Q')
172: and

Line 237: if p_effective_date < fnd_date.canonical_to_date('2007/05/17') then

233: -- Update 37 09-NOV-2004 MADHURI Delete pay plans AA, AL,
234: -- CA, SK, and SO.
235: -------------------------------------------------------------------------------
236: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 17-May-2007
237: if p_effective_date < fnd_date.canonical_to_date('2007/05/17') then
238: if p_to_pay_plan in ('ES','EX','GM','SL','ST')
239: and
240: p_retention_allowance is not null
241: and

Line 440: if p_effective_date < fnd_date.canonical_to_date('2007/07/18') then

436: end if;
437:
438: -- 660.10.2
439: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 17-Jul-2007
440: if p_effective_date < fnd_date.canonical_to_date('2007/07/18') then
441: if substr(p_first_noac_lookup_code, 1, 1) = '1'
442: -- and
443: -- hr_utility.is_numeric(p_credit_mil_svc)
444: and

Line 464: IF p_effective_date >= fnd_date.canonical_to_date('2011/02/01') THEN

460: ,p_employee_date_of_birth in date
461: ) IS
462:
463: begin
464: IF p_effective_date >= fnd_date.canonical_to_date('2011/02/01') THEN
465: -- 665.01.1/665.01.2
466: if p_scd_retirement > p_effective_date and p_scd_retirement is not null then
467: hr_utility.set_message(8301, 'GHR_38353_ALL_PROCEDURE_FAIL');
468: hr_utility.raise_error;

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

624: -- 06/26/03 vravikan Use p_rpa_step_or_rate if g_temp_step is not null
625: -- becuase p_step_or_rate contains TPS value
626: -- 12/11/08 Raju Start date 7633560 Exclude D
627: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
628: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
629: IF GHR_GHRWS52L.g_temp_step is not null THEN
630: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then
631: if (
632: p_pay_rate_determinant in ('0','6','2','3','4','A','B','C','E','F','G','H',

Line 630: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then

626: -- 12/11/08 Raju Start date 7633560 Exclude D
627: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
628: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
629: IF GHR_GHRWS52L.g_temp_step is not null THEN
630: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then
631: if (
632: p_pay_rate_determinant in ('0','6','2','3','4','A','B','C','E','F','G','H',
633: 'I','J','K','L','N','O',
634: 'Q','R','S','U','V','W','X','Y','Z')

Line 661: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then

657: hr_utility.raise_error;
658: end if;
659: end if;
660: ELSE
661: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then
662: if (
663: p_pay_rate_determinant in ('2','3','4','A','B','C','E','F','G','H',
664: 'I','J','K','L','N','O',
665: 'Q','R','S','U','V','W','X','Y','Z')

Line 697: IF p_effective_date < fnd_date.canonical_to_date('2009/09/01') THEN

693: -- 700.04.3
694: -- -- Madhuri 19-MAY-2004 Included VP in the list
695: -- U58 Raju 01-Sep-2009 Bug 9503972 added GL
696: --
697: IF p_effective_date < fnd_date.canonical_to_date('2009/09/01') THEN
698: if (p_to_pay_plan in ('GG','GS','VP')) and
699: p_Cur_Appt_Auth_1 <> 'UAM' and
700: p_Cur_Appt_Auth_2 <> 'UAM' and
701: (p_to_grade_or_level between '01' and '15') and

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

725: -- 700.07.3
726: -- Madhuri 19-MAY-2004 Removed VP from the list
727: -- 13-Jun-06 Raju Terminate the edit eff from 01-Jan-03
728: --
729: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
730: if (p_to_pay_plan ='VM' ) and /*or p_to_pay_plan ='VP') */
731: p_to_grade_or_level <> 97 and
732: p_step_or_rate not in ('01','02','03','04','05','06',
733: '07','08','09','10') and

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

740:
741: -- 700.10.3
742: -- Update/Change Date By Effective Date Comment
743: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
744: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
745: if p_to_pay_plan = 'VM' and p_to_grade_or_level = '97' and
746: p_step_or_rate not in ('01','02','03','04','05','06',
747: '07','08','09') and
748: p_step_or_rate is not null

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

753: END IF;
754:
755: -- 700.12.3
756: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
757: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
758: if p_to_pay_plan = 'VN' and
759: p_step_or_rate not in ('00','01','02','03','04','05','06','07',
760: '08','09','10','11','12','13','14','15',
761: '16','17','18','19','20','21','22','23',

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

771: -- 700.14.3
772: -- Update 7 on 16 jun 98. Added 00 to step or rate
773: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added 611,613
774: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
775: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
776: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
777: if p_to_pay_plan = 'XE' and
778: p_step_or_rate not in ('00','01','02','03') and
779: p_step_or_rate is not null then

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

772: -- Update 7 on 16 jun 98. Added 00 to step or rate
773: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added 611,613
774: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
775: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
776: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
777: if p_to_pay_plan = 'XE' and
778: p_step_or_rate not in ('00','01','02','03') and
779: p_step_or_rate is not null then
780: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');

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

793: end if;
794:
795: -- 700.16.3
796: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
797: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
798: if (p_to_pay_plan ='CE' or p_to_pay_plan ='CY') and
799: p_step_or_rate not in ('00','01','02','03','04','05','06','07',
800: '08','09','10','11','12','13','14','15',
801: '16','17','18','19','20','21')

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

810: -- 700.19.3
811: -- 17-Aug-00 vravikan 01-jan-2000 Delete 99
812: -- 06-Aug-07 Raju 5132113 Added GR Phy and Dentist change
813: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
814: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
815: if p_effective_date >= to_date('1999/01/01','yyyy/mm/dd') then
816: if p_to_pay_plan in ('GR','GM') and p_step_or_rate <> '00' and
817: p_step_or_rate is not null
818: then

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

869: end if;
870:
871: -- 700.35.3
872: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
873: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
874: if p_to_pay_plan = 'FP' and
875: p_to_grade_or_level in ('AA','BB','CC','DD','EE') and
876: p_step_or_rate not in ('01','02','03','04','05')
877: and

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

883: end if;
884:
885: -- 700.37.3
886: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
887: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
888: if p_to_pay_plan = 'AF' and
889: p_step_or_rate not in ('01','02','03','04','05')
890: and
891: p_step_or_rate is not null

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

896: end if;
897:
898: -- 700.40.3
899: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
900: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
901: if p_to_pay_plan = 'FC' and
902: p_to_grade_or_level in ('02','03','04','05','06','07',
903: '08','09','10','11','12') and
904: p_step_or_rate not in ('01','02','03','04','05','06',

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

912: end if;
913:
914: -- 700.43.3
915: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
916: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
917: if p_to_pay_plan = 'FC' and p_to_grade_or_level = '13' and
918: p_step_or_rate not in ('01','02','03','04','05',
919: '06','07','08','09')
920: and

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

926: end if;
927:
928: -- 700.47.3
929: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
930: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
931: if p_to_pay_plan = 'FC' and p_to_grade_or_level = '14' and
932: p_step_or_rate not in ('01','02','03','04','05')
933: and
934: p_step_or_rate is not null

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

939: end if;
940:
941: -- 700.50.3
942: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
943: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
944: if p_to_pay_plan in ('CA','SL','ST') and
945: p_step_or_rate <> '00'
946: and
947: p_step_or_rate is not null

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

953: end if;
954:
955: -- 700.55.3
956: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
957: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
958: if p_to_pay_plan = 'AL' and
959: (p_to_grade_or_level = '01' or p_to_grade_or_level = '02') and
960: (p_step_or_rate <> '00'
961: and

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

978: end if;
979:
980: -- 700.62.3
981: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
982: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
983: if p_to_pay_plan = 'GG' and p_to_grade_or_level = 'SL' and
984: p_step_or_rate <>'00'
985: and
986: p_step_or_rate is not null

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

1007: end if;
1008:
1009: -- 700.67.3
1010: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1011: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1012: if p_to_pay_plan = 'FG'
1013: and
1014: p_step_or_rate not in ('01','02','03','04','05','06',
1015: '07','08','09','10', '00')

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

1026: And pay rate determinant is 0 or 7,
1027: Then step or rate must be 01 through 04 or asterisks.
1028: Default: Insert asterisks in step or rate. */
1029: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1030: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1031: if p_to_pay_plan = 'IJ' and
1032: p_pay_rate_determinant in ('0','7') and
1033: p_step_or_rate not in ('01','02','03','04') and
1034: p_step_or_rate is not null then

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

1289: -- 01-Oct-01 -- Delete YAM and Y4M
1290: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan condition
1291: --Upd57 01-Mar-09 Mani From 01-Mar-2009 ---Removed Pay Plan Condition
1292:
1293: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1294: if p_effective_date >= to_date('2001/10/01','yyyy/mm/dd') then
1295: if p_first_action_noa_la_code1 in ('YBM','YCM','YGM',
1296: 'Y1M','Y2M','Y3M') and
1297: p_tenure_group_code <>'2' and

Line 1311: elsif p_effective_date < fnd_date.canonical_to_date('2009/03/01') then

1307: hr_utility.set_message(8301, 'GHR_37651_ALL_PROCEDURE_FAIL');
1308: hr_utility.raise_error;
1309: end if;
1310: end if;
1311: elsif p_effective_date < fnd_date.canonical_to_date('2009/03/01') then
1312: if p_first_action_noa_la_code1 in ('YAM','YBM','YCM','YGM',
1313: 'Y1M','Y2M','Y3M','Y4M') and
1314: substr(p_to_pay_plan,1,1) in ('Y') and
1315: p_tenure_group_code <>'2' and

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

1366: end if;
1367:
1368: -- 720.34.2
1369: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1370: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1371: if (p_first_noac_lookup_code = '892' or p_first_noac_lookup_code = '893')
1372: and
1373: p_to_pay_plan = 'GS' and
1374: p_tenure_group_code = '0' then