APPS.OKC_TERMS_UTIL_GRP dependencies on FND_LOOKUPS

Line 2995: l_contract_source FND_LOOKUPS.MEANING%TYPE;

2991: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
2992: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
2993: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
2994: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
2995: l_contract_source FND_LOOKUPS.MEANING%TYPE;
2996:
2997: CURSOR terms_tmpl_csr IS
2998: SELECT tu.document_id,
2999: tu.authoring_party_code,

Line 3010: fnd_lookups src

3006: FROM OKC_TEMPLATE_USAGES tu,
3007: OKC_TERMS_TEMPLATES_ALL t,
3008: okc_resp_parties_vl party,
3009: okc_bus_doc_types_b doc,
3010: fnd_lookups src
3011: WHERE t.template_id(+) = tu.template_id
3012: AND tu.authoring_party_code = party.resp_party_code
3013: AND tu.document_type = doc.document_type
3014: AND doc.document_type_class = party.document_type_class

Line 3148: l_contract_source FND_LOOKUPS.MEANING%TYPE;

3144: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3145: l_generated_flag VARCHAR2(1) := '?';
3146: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3147: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3148: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3149:
3150: CURSOR terms_tmpl_csr IS
3151: SELECT tu.document_id,
3152: tu.authoring_party_code,

Line 3164: fnd_lookups src

3160: FROM OKC_TEMPLATE_USAGES tu,
3161: OKC_TERMS_TEMPLATES_ALL t,
3162: okc_resp_parties_vl party,
3163: okc_bus_doc_types_b doc,
3164: fnd_lookups src
3165: WHERE t.template_id(+) = tu.template_id
3166: AND tu.authoring_party_code = party.resp_party_code
3167: AND tu.document_type = doc.document_type
3168: AND doc.document_type_class = party.document_type_class

Line 3202: fnd_lookups src

3198: FROM OKC_TEMPLATE_USAGES_H tu,
3199: OKC_TERMS_TEMPLATES_ALL t,
3200: okc_resp_parties_vl party,
3201: okc_bus_doc_types_b doc,
3202: fnd_lookups src
3203: WHERE t.template_id(+) = tu.template_id
3204: AND tu.authoring_party_code = party.resp_party_code
3205: AND tu.document_type = doc.document_type
3206: AND doc.document_type_class = party.document_type_class