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 1687: from sys.dual;

1683: hr_utility.set_location('Entering:'||l_proc, 10);
1684: -- Get the next item key from the sequence
1685: select hr_workflow_item_key_s.nextval
1686: into l_item_key
1687: from sys.dual;
1688:
1689:
1690: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1691:

Line 1993: Select nvl(fnd_profile.value('OTA_ALLOW_COMPETENCY_UPDATE_WITH_RENEWAL_PERIOD'),'N') from dual;

1989: --AND pc.renewal_period_units IS NOT NULL modified for bug8410902
1990: AND pc.renewal_period_units IN ('Y','D','H','MIN','M','Q','W');
1991:
1992: Cursor get_comp_profile is
1993: Select nvl(fnd_profile.value('OTA_ALLOW_COMPETENCY_UPDATE_WITH_RENEWAL_PERIOD'),'N') from dual;
1994:
1995: CURSOR csr_get_lp_comps IS
1996: SELECT pce.competence_id CompetenceId
1997: ,nvl(pce.proficiency_level_id,-1) LevelId