APPS.PA_CBS_LEVEL_HIERARCHY_PVT dependencies on DUAL

Line 45: From Dual;

41: STRUCTURE_LEVEL = P_Structure_Level;
42:
43: cursor getCbsStructLevelId IS
44: Select PA_CBS_HIERARCHY_S.NextVal
45: From Dual;
46:
47: BEGIN
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 142: select 'N' from dual;

138: UNABLE_TO_UPDATE_LEVEL Exception;
139: L_CostCategoryUsed Varchar2(1);
140:
141: cursor checkLevelUsed IS
142: select 'N' from dual;
143:
144: BEGIN
145:
146: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 218: select IS_CBS_USED(P_CbsHeaderId) from dual;

214: UNABLE_TO_DELETE_LEVEL Exception;
215: L_CostCategoryUsed Varchar2(1);
216:
217: cursor checkLevelUsed IS
218: select IS_CBS_USED(P_CbsHeaderId) from dual;
219:
220: BEGIN
221:
222: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 278: select 'Y' from dual where

274: IS
275: L_TEMP VARCHAR2(1);
276:
277: CURSOR C1 is
278: select 'Y' from dual where
279: EXISTS
280: (SELECT *
281: FROM PA_PROJECTS_ALL
282: WHERE CBS_VERSION_ID =