APPS.OKL_VENDOR_PROGRAM_PVT dependencies on OKC_QA_CHECK_LISTS_V

Line 145: SELECT id FROM OKC_QA_CHECK_LISTS_V WHERE name = p_qa_name;

141:
142: --Manu : 14-Jun-2005
143: -- Cursor to get the QA Process ID for Operating/Program Agreement
144: CURSOR qa_csr(p_qa_name VARCHAR2) IS
145: SELECT id FROM OKC_QA_CHECK_LISTS_V WHERE name = p_qa_name;
146:
147: l_qa_id OKC_QA_CHECK_LISTS_V .id%TYPE := NULL;
148:
149: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;

Line 147: l_qa_id OKC_QA_CHECK_LISTS_V .id%TYPE := NULL;

143: -- Cursor to get the QA Process ID for Operating/Program Agreement
144: CURSOR qa_csr(p_qa_name VARCHAR2) IS
145: SELECT id FROM OKC_QA_CHECK_LISTS_V WHERE name = p_qa_name;
146:
147: l_qa_id OKC_QA_CHECK_LISTS_V .id%TYPE := NULL;
148:
149: l_access_level OKC_ROLE_SOURCES.access_level%TYPE;
150:
151: BEGIN