APPS.OKC_REP_UTIL_PVT dependencies on DUAL

Line 2571: FROM DUAL;

2567: l_imp_error_id NUMBER;
2568:
2569: CURSOR ERROR_ID_CSR IS
2570: SELECT OKC_REP_IMP_ERRORS_T_S.NEXTVAL
2571: FROM DUAL;
2572:
2573: BEGIN
2574:
2575: l_api_name := 'populate_import_errors';

Line 3655: FROM DUAL;

3651: l_contract_intent VARCHAR2(30);
3652:
3653: CURSOR CONTRACT_ID_CSR IS
3654: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL
3655: FROM DUAL;
3656:
3657: CURSOR CONTRACT_NUMBER_CSR IS
3658: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3659: FROM DUAL;

Line 3659: FROM DUAL;

3655: FROM DUAL;
3656:
3657: CURSOR CONTRACT_NUMBER_CSR IS
3658: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3659: FROM DUAL;
3660:
3661: CURSOR CONTRACT_NUMBER_UNIQUE_CSR (p_contract_number VARCHAR2, p_imp_contract_id NUMBER) IS
3662: SELECT CONTRACT_NUMBER
3663: FROM OKC_REP_CONTRACTS_ALL

Line 7429: SELECT Nvl((SELECT 'Y' FROM okc_template_usages WHERE document_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_contract_terms_yn FROM dual;

7425:
7426: END IF;
7427:
7428:
7429: SELECT Nvl((SELECT 'Y' FROM okc_template_usages WHERE document_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_contract_terms_yn FROM dual;
7430:
7431:
7432:
7433: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN