APPS.OKC_REP_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_V

Line 3403: FROM OKC_BUS_DOC_TYPES_V bus_doc,

3399: l_import_parties_rec IMPORT_PARTIES_CSR%ROWTYPE;
3400:
3401: CURSOR CONTRACT_INTENT_CSR (p_imp_contract_id NUMBER) IS
3402: SELECT INTENT
3403: FROM OKC_BUS_DOC_TYPES_V bus_doc,
3404: OKC_REP_IMP_CONTRACTS_T temp
3405: WHERE bus_doc.name = temp.contract_type_txt
3406: AND temp.imp_contract_id = p_imp_contract_id
3407: AND bus_doc.document_type_class = 'REPOSITORY';

Line 4052: FROM OKC_BUS_DOC_TYPES_V

4048: AND UPPER(MEANING) = UPPER(p_status_txt);
4049:
4050: CURSOR CONTRACT_TYPE_CSR (p_type_txt VARCHAR2) IS
4051: SELECT DOCUMENT_TYPE
4052: FROM OKC_BUS_DOC_TYPES_V
4053: WHERE DOCUMENT_TYPE_CLASS = 'REPOSITORY'
4054: AND UPPER(NAME) = UPPER(p_type_txt);
4055:
4056: CURSOR CONTRACT_INTENT_CSR (p_imp_contract_id NUMBER) IS

Line 4058: FROM OKC_BUS_DOC_TYPES_V bus_doc,

4054: AND UPPER(NAME) = UPPER(p_type_txt);
4055:
4056: CURSOR CONTRACT_INTENT_CSR (p_imp_contract_id NUMBER) IS
4057: SELECT INTENT
4058: FROM OKC_BUS_DOC_TYPES_V bus_doc,
4059: OKC_REP_IMP_CONTRACTS_T temp
4060: WHERE bus_doc.name = temp.contract_type_txt
4061: AND temp.imp_contract_id = p_imp_contract_id
4062: AND bus_doc.document_type_class = 'REPOSITORY';