APPS.GHR_VALIDATE_PERWSDPO dependencies on FND_DATE

Line 110: if nvl(fnd_date.canonical_to_date(l_date_from),sysdate) > sysdate

106: END LOOP;
107:
108: if l_pos_desc_id is not null then
109:
110: if nvl(fnd_date.canonical_to_date(l_date_from),sysdate) > sysdate
111: and nvl(fnd_date.canonical_to_date(l_date_to),sysdate) <= sysdate then
112:
113: /* get values from DDFs */
114:

Line 111: and nvl(fnd_date.canonical_to_date(l_date_to),sysdate) <= sysdate then

107:
108: if l_pos_desc_id is not null then
109:
110: if nvl(fnd_date.canonical_to_date(l_date_from),sysdate) > sysdate
111: and nvl(fnd_date.canonical_to_date(l_date_to),sysdate) <= sysdate then
112:
113: /* get values from DDFs */
114:
115: FOR c_pos_extra_info_DDF1_rec IN c_pos_extra_info_DDF1 LOOP

Line 263: OR fnd_date.canonical_to_date(l_expire_date) >= p_date )

259:
260: l_expire_date := l_pos_ei_data.POEI_INFORMATION3;
261: l_obligate_type := l_pos_ei_data.POEI_INFORMATION4;
262: if (l_expire_date IS NULL
263: OR fnd_date.canonical_to_date(l_expire_date) >= p_date )
264: and NVL(l_obligate_type,'U') <> 'U' then
265: l_chk_position_obligated :=true;
266: else
267: l_chk_position_obligated :=false;