APPS.OKC_TERMS_QA_PVT dependencies on OKC_DOC_QA_LISTS

Line 245: severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE,

241:
242: TYPE qa_detail_type IS RECORD (
243: qa_code FND_LOOKUPS.LOOKUP_CODE%TYPE,
244: qa_name FND_LOOKUPS.MEANING%TYPE,
245: severity_flag OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE,
246: perform_qa VARCHAR2(1)
247: );
248:
249: TYPE qa_detail_tbl_type IS TABLE OF qa_detail_type INDEX BY BINARY_INTEGER;

Line 976: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA

972: SELECT
973: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa,
974: fnd.meaning qa_name,
975: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag
976: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA
977: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
978: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
979: AND Fnd.LOOKUP_TYPE=G_QA_LOOKUP
980: AND fnd.lookup_code = p_qa_code;

Line 985: FROM OKC_DOC_QA_LISTS QA

981:
982:
983: CURSOR l_get_lock_error_warn_csr IS
984: SELECT nvl(qa.severity_flag,G_QA_STS_ERROR) severity_flag
985: FROM OKC_DOC_QA_LISTS QA
986: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
987: AND QA.QA_CODE(+) = G_OKC_CHECK_LOCK_CONTRACT;
988:
989:

Line 1112: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA

1108: SELECT
1109: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa,
1110: fnd.meaning qa_name,
1111: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag
1112: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA
1113: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
1114: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
1115: AND Fnd.LOOKUP_TYPE=G_QA_LOOKUP
1116: AND fnd.lookup_code = p_qa_code;

Line 1122: FROM OKC_DOC_QA_LISTS QA

1118:
1119:
1120: CURSOR l_get_ctrt_admin_err_wrn_csr IS
1121: SELECT nvl(qa.severity_flag,G_QA_STS_ERROR) severity_flag
1122: FROM OKC_DOC_QA_LISTS QA
1123: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
1124: AND QA.QA_CODE(+) = G_OKC_CHECK_CONTRACT_ADMIN;
1125:
1126: CURSOR contract_admin_exists is

Line 4403: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA

4399: SELECT fnd.lookup_code qa_code,
4400: fnd.meaning qa_name,
4401: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
4402: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
4403: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA
4404: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
4405: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
4406: AND Fnd.LOOKUP_TYPE=G_QA_LOOKUP;
4407: