APPS.OTA_COMPETENCE_SS dependencies on DUAL

Line 221: select trunc(sysdate) into l_eff_date from dual;

217: if p_obj_type='COURSE' then
218: OPEN course_eff_date;
219: FETCH course_eff_date INTO l_eff_date;
220: if course_eff_date%notfound then
221: select trunc(sysdate) into l_eff_date from dual;
222: end if;
223: CLOSE course_eff_date;
224: else
225: select trunc(sysdate) into l_eff_date from dual;

Line 225: select trunc(sysdate) into l_eff_date from dual;

221: select trunc(sysdate) into l_eff_date from dual;
222: end if;
223: CLOSE course_eff_date;
224: else
225: select trunc(sysdate) into l_eff_date from dual;
226: end if;
227: hr_utility.set_location('Leaving:'||l_proc, 5);
228: return l_eff_date;
229:

Line 858: select INSTR(inString,'^',startPos) into l_posFound from dual;

854: l_posFound number(15);
855:
856: begin
857:
858: select INSTR(inString,'^',startPos) into l_posFound from dual;
859:
860: if l_posFound=0 then --implies last string token
861: select SUBSTR(inString,startPos,((length(inString)+1)-startPos)) into l_value from dual;
862: else

Line 861: select SUBSTR(inString,startPos,((length(inString)+1)-startPos)) into l_value from dual;

857:
858: select INSTR(inString,'^',startPos) into l_posFound from dual;
859:
860: if l_posFound=0 then --implies last string token
861: select SUBSTR(inString,startPos,((length(inString)+1)-startPos)) into l_value from dual;
862: else
863: select SUBSTR(inString,startPos,(l_posFound-startPos)) into l_value from dual;
864: end if;
865:

Line 863: select SUBSTR(inString,startPos,(l_posFound-startPos)) into l_value from dual;

859:
860: if l_posFound=0 then --implies last string token
861: select SUBSTR(inString,startPos,((length(inString)+1)-startPos)) into l_value from dual;
862: else
863: select SUBSTR(inString,startPos,(l_posFound-startPos)) into l_value from dual;
864: end if;
865:
866:
867: endPos :=l_posFound ;

Line 1675: from sys.dual;

1671: hr_utility.set_location('Entering:'||l_proc, 10);
1672: -- Get the next item key from the sequence
1673: select hr_workflow_item_key_s.nextval
1674: into l_item_key
1675: from sys.dual;
1676:
1677:
1678: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1679: