APPS.OKC_TERMS_QA_PVT dependencies on FND_LOOKUPS

Line 243: qa_code FND_LOOKUPS.LOOKUP_CODE%TYPE,

239: scn_code OKC_SECTIONS_B.scn_code%TYPE
240: );
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: );

Line 244: qa_name FND_LOOKUPS.MEANING%TYPE,

240: );
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:

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 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 4437: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA

4433: SELECT fnd.lookup_code qa_code,
4434: fnd.meaning qa_name,
4435: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
4436: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
4437: FROM FND_LOOKUPS FND, OKC_DOC_QA_LISTS QA
4438: WHERE QA.DOCUMENT_TYPE(+)=p_doc_type
4439: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
4440: AND Fnd.LOOKUP_TYPE=G_QA_LOOKUP;
4441: