APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on FND_LOOKUPS

Line 7: FROM fnd_lookups

3: AS
4: CURSOR cur_val_lookup (p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2)
5: IS
6: SELECT 'Y'
7: FROM fnd_lookups
8: WHERE lookup_type = p_lookup_type
9: AND lookup_code = p_lookup_code
10: AND enabled_flag = 'Y'
11: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, SYSDATE - 1)

Line 22: FROM fnd_lookups

18: p_lookup_code IN VARCHAR2
19: )
20: IS
21: SELECT 'Y', meaning
22: FROM fnd_lookups
23: WHERE lookup_type = p_lookup_type
24: AND lookup_code = p_lookup_code
25: AND enabled_flag = 'Y'
26: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, SYSDATE - 1)

Line 685: FROM okc_bus_doc_types_b bus, fnd_lookups fnd

681: l_tmpl_intent VARCHAR2 (120) := g_template_intent;
682: BEGIN
683: SELECT 'Y'
684: INTO l_valid_bus_doc_type
685: FROM okc_bus_doc_types_b bus, fnd_lookups fnd
686: WHERE bus.document_type <> 'TEMPLATE'
687: AND DECODE (bus.document_type_class,
688: 'REPOSITORY', NVL (bus.enable_contract_terms_yn, 'N'),
689: NVL (bus.show_in_lov_yn, 'Y')