APPS.OKE_DELIVERABLE_PVT dependencies on DUAL

Line 251: FROM DUAL

247: AND PROJECT_ID IS NOT NULL;
248:
249: CURSOR C (P_ID NUMBER, P_ID1 NUMBER, P_ID2 NUMBER) IS
250: SELECT 'X'
251: FROM DUAL
252: WHERE P_ID IN (
253: SELECT P.Project_ID
254: FROM pa_projects_all p
255: WHERE p.Project_ID IN (SELECT To_Number(sub_project_id)

Line 3074: /* call individual validation procedure */

3070: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
3071: x_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
3072:
3073: BEGIN
3074: /* call individual validation procedure */
3075:
3076:
3077: Validate_Header_ID(
3078: x_return_status => l_return_status,

Line 3612: select oke_k_deliverables_s.nextval from dual;

3608: x_del_rec OUT NOCOPY del_rec_type
3609: ) RETURN VARCHAR2 IS
3610: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
3611: cursor l_csr is
3612: select oke_k_deliverables_s.nextval from dual;
3613:
3614: BEGIN
3615:
3616: x_del_rec := p_del_rec;