APPS.GHR_CPDF_CHECK6 dependencies on FND_DATE

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

568: -- becuase p_step_or_rate contains TPS value
569: -- 12/11/08 Raju Start date 7633560 Exclude D
570:
571: IF GHR_GHRWS52L.g_temp_step is not null THEN
572: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then
573: if (
574: p_pay_rate_determinant in ('0','6','2','3','4','A','B','C','E','F','G','H',
575: 'I','J','K','L','N','O',
576: 'Q','R','S','U','V','W','X','Y','Z')

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

599: hr_utility.raise_error;
600: end if;
601: end if;
602: ELSE
603: if p_effective_date >= fnd_date.canonical_to_date('1999/03/01') then
604: if (
605: p_pay_rate_determinant in ('2','3','4','A','B','C','E','F','G','H',
606: 'I','J','K','L','N','O',
607: 'Q','R','S','U','V','W','X','Y','Z')

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

657: -- 700.07.3
658: -- Madhuri 19-MAY-2004 Removed VP from the list
659: -- 13-Jun-06 Raju Terminate the edit eff from 01-Jan-03
660: --
661: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
662: if (p_to_pay_plan ='VM' ) and /*or p_to_pay_plan ='VP') */
663: p_to_grade_or_level <> 97 and
664: p_step_or_rate not in ('01','02','03','04','05','06',
665: '07','08','09','10') and

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

672:
673: -- 700.10.3
674: -- Update/Change Date By Effective Date Comment
675: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
676: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
677: if p_to_pay_plan = 'VM' and p_to_grade_or_level = '97' and
678: p_step_or_rate not in ('01','02','03','04','05','06',
679: '07','08','09') and
680: p_step_or_rate is not null

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

699:
700: -- 700.14.3
701: -- Update 7 on 16 jun 98. Added 00 to step or rate
702: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added 611,613
703: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
704: if p_to_pay_plan = 'XE' and
705: p_step_or_rate not in ('00','01','02','03') and
706: p_step_or_rate is not null then
707: hr_utility.set_message(8301, 'GHR_37621_ALL_PROCEDURE_FAIL');

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

1178: -- 720.22.2
1179: -- Dec 01 Patch 12/10/01 vravikan From the Begining -- Add YCM
1180: -- 01-Oct-01 -- Delete YAM and Y4M
1181: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan condition
1182: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1183: if p_effective_date >= to_date('2001/10/01','yyyy/mm/dd') then
1184: if p_first_action_noa_la_code1 in ('YBM','YCM','YGM',
1185: 'Y1M','Y2M','Y3M') and
1186: p_tenure_group_code <>'2' and