APPS.GHR_CPDF_CHECK4 dependencies on FND_DATE

Line 37: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then

33: --
34: -- 12/8/00 vravikan From the start Add UAM
35: -- If either legal authority is Z2U, then agency must be AF,AR,DD or NV
36: --
37: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
38: if (p_First_Action_NOA_LA_Code1 in ('Z2U','UAM') or
39: p_First_Action_NOA_LA_Code2 in ('Z2U','UAM') ) and
40: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
41: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');

Line 52: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then

48: -- Raju 09-Nov-2005 UPD 43(Bug 4567571) Add Edit
49: --
50: -- If either legal authority is ZPK, then agency must be PC
51: --
52: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
53: if (p_First_Action_NOA_LA_Code1 = 'ZPK' or
54: p_First_Action_NOA_LA_Code2 = 'ZPK' ) and
55: substr(p_agency_sub_element,1,2) <> 'PC' then
56: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');

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

70: --
71: -- 250.05.2 If either legal authority is Z2W,
72: -- Then agency must be AF, AR, DD, or NV.
73: --
74: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
75: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
76: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
77: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
78: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');

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

84: -- 250.06.2 If either legal authority is ZTA,
85: -- And position occupied is 1,
86: -- Then agency/subelement must be DJ03.
87: --
88: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
89: if (p_First_Action_NOA_LA_Code1 = 'ZTA' or
90: p_First_Action_NOA_LA_Code2 = 'ZTA' ) and
91: p_position_occupied_code = '1' and
92: p_agency_sub_element <> 'DJ03' then

Line 107: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then

103: -- ============================================
104: -- 19-MAR-2003 vnarasim Added agency/subelement HSBC.
105: -- 30-OCT-2003 Ashley Deleted agency/subelement TD19
106: --
107: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
108: if (p_First_Action_NOA_LA_Code1 = 'ZVC' or
109: p_First_Action_NOA_LA_Code2 = 'ZVC' ) and
110: p_agency_sub_element NOT IN ('HSBC') then
111: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');

Line 717: if p_effective_date < fnd_date.canonical_to_date('19'||'99/02/27') then

713: -- Update/Change Date By Effective Date Comment
714: -- 8/5 03/09/99 vravikan From the Start Add BWA
715: -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM
716:
717: if p_effective_date < fnd_date.canonical_to_date('19'||'99/02/27') then
718: if p_First_NOAC_Lookup_Code= '107'
719: and
720: NOT(
721: p_First_Action_NOA_LA_Code1 in

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

1112:
1113: --275.01.2
1114: -- added effective date
1115: -- added la code Z2U on 23-jul-98
1116: if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
1117: if p_First_NOAC_Lookup_Code= '130'
1118: and
1119: NOT ( p_First_Action_NOA_LA_Code1 in
1120: ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',