DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on FND_LOOKUPS

Line 3105: l_contract_source FND_LOOKUPS.MEANING%TYPE;

3101: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
3102: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3103: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3104: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3105: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3106:
3107: CURSOR terms_tmpl_csr IS
3108: SELECT tu.document_id,
3109: tu.authoring_party_code,

Line 3120: fnd_lookups src

3116: FROM OKC_TEMPLATE_USAGES tu,
3117: OKC_TERMS_TEMPLATES_ALL t,
3118: okc_resp_parties_vl party,
3119: okc_bus_doc_types_b doc,
3120: fnd_lookups src
3121: WHERE t.template_id(+) = tu.template_id
3122: AND tu.authoring_party_code = party.resp_party_code
3123: AND tu.document_type = doc.document_type
3124: AND doc.document_type_class = party.document_type_class

Line 3258: l_contract_source FND_LOOKUPS.MEANING%TYPE;

3254: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3255: l_generated_flag VARCHAR2(1) := '?';
3256: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3257: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3258: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3259:
3260: CURSOR terms_tmpl_csr IS
3261: SELECT tu.document_id,
3262: tu.authoring_party_code,

Line 3274: fnd_lookups src

3270: FROM OKC_TEMPLATE_USAGES tu,
3271: OKC_TERMS_TEMPLATES_ALL t,
3272: okc_resp_parties_vl party,
3273: okc_bus_doc_types_b doc,
3274: fnd_lookups src
3275: WHERE t.template_id(+) = tu.template_id
3276: AND tu.authoring_party_code = party.resp_party_code
3277: AND tu.document_type = doc.document_type
3278: AND doc.document_type_class = party.document_type_class

Line 3312: fnd_lookups src

3308: FROM OKC_TEMPLATE_USAGES_H tu,
3309: OKC_TERMS_TEMPLATES_ALL t,
3310: okc_resp_parties_vl party,
3311: okc_bus_doc_types_b doc,
3312: fnd_lookups src
3313: WHERE t.template_id(+) = tu.template_id
3314: AND tu.authoring_party_code = party.resp_party_code
3315: AND tu.document_type = doc.document_type
3316: AND doc.document_type_class = party.document_type_class