APPS.OKC_XPRT_UTIL_PVT dependencies on FND_LOOKUPS

Line 2226: l_section_name FND_LOOKUPS.MEANING%TYPE;

2222:
2223: l_tmpl_active_rule_exists VARCHAR2(1);
2224: l_template_name okc_terms_templates_all.template_name%TYPE;
2225: l_XPRT_SCN_CODE okc_terms_templates_all.XPRT_SCN_CODE%TYPE;
2226: l_section_name FND_LOOKUPS.MEANING%TYPE;
2227:
2228: CURSOR csr_template_dtls IS
2229: SELECT contract_expert_enabled , template_name , XPRT_SCN_CODE
2230: FROM okc_terms_templates_all

Line 2275: FROM fnd_lookups

2271:
2272: -- bug 4120816
2273: CURSOR cst_tmpl_def_section (p_scn_code VARCHAR2) IS
2274: SELECT meaning
2275: FROM fnd_lookups
2276: WHERE lookup_type = 'OKC_ARTICLE_SECTION'
2277: AND lookup_code = p_scn_code
2278: AND sysdate not between start_date_active and nvl(end_date_active,sysdate) ;
2279:

Line 6509: FROM FND_LOOKUPS FND,

6505: CURSOR l_get_qa_detail_csr IS
6506: SELECT fnd.meaning qa_name,
6507: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
6508: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
6509: FROM FND_LOOKUPS FND,
6510: OKC_DOC_QA_LISTS QA
6511: WHERE QA.DOCUMENT_TYPE(+)=p_document_type
6512: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
6513: AND Fnd.LOOKUP_TYPE='OKC_TERM_QA_LIST'