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;

Line 343: and p_effective_date <= fnd_date.canonical_to_date(aei_information2);

339: cursor c_det_pos_next is
340: select assignment_id from per_assignment_extra_info
341: where information_type = 'GHR_US_ASG_DET_INFO'
342: and to_number(aei_information5) = p_position_id
343: and p_effective_date <= fnd_date.canonical_to_date(aei_information2);
344:
345: begin
346: FOR c_det_pos_next_rec IN c_det_pos_next LOOP
347: RETURN(TRUE);