APPS.OKC_XPRT_UTIL_PVT dependencies on FND_LOOKUPS

Line 2228: l_section_name FND_LOOKUPS.MEANING%TYPE;

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

Line 2277: FROM fnd_lookups

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

Line 6707: FROM FND_LOOKUPS FND,

6703: CURSOR l_get_qa_detail_csr IS
6704: SELECT fnd.meaning qa_name,
6705: nvl(qa.severity_flag,G_QA_STS_WARNING) severity_flag ,
6706: decode(fnd.enabled_flag,'N','N','Y',decode(qa.enable_qa_yn,'N','N','Y'),'Y') perform_qa
6707: FROM FND_LOOKUPS FND,
6708: OKC_DOC_QA_LISTS QA
6709: WHERE QA.DOCUMENT_TYPE(+)=p_document_type
6710: AND QA.QA_CODE(+) = FND.LOOKUP_CODE
6711: AND Fnd.LOOKUP_TYPE='OKC_TERM_QA_LIST'