APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 307: FROM okc_bus_doc_types_b b, okc_bus_doc_types_tl tl

303:
304: CURSOR BUSDOC_TYPE IS
305: SELECT tl.name,b.document_type_class,
306: b.external_userlist_proc,b.notification_header_function
307: FROM okc_bus_doc_types_b b, okc_bus_doc_types_tl tl
308: WHERE b.document_type = tl.document_type
309: AND tl.language = userenv('LANG')
310: AND b.document_type = p_business_document_type;
311: busdoc_type_rec busdoc_type%ROWTYPE;

Line 324: okc_bus_doc_types_b docType,

320: -- updated cursor for bug#4069955
321: CURSOR delTypeInternalFlag is
322: select delType.internal_flag
323: from okc_deliverable_types_b delType,
324: okc_bus_doc_types_b docType,
325: okc_del_bus_doc_combxns delComb
326: where delType.deliverable_type_code = p_deliverable_type
327: and docType.document_type = p_business_document_type
328: and docType.document_type_class = delComb.document_type_class

Line 337: ,okc_bus_doc_types_b docType

333: CURSOR getRespPartyCode IS
334: select resp_party_code
335: from
336: okc_resp_parties_b delrsp
337: ,okc_bus_doc_types_b docType
338: where delrsp.resp_party_code = p_resp_party
339: and doctype.document_type = p_business_document_type
340: and delrsp.document_type_class = docType.document_type_class
341: and delrsp.intent = docType.intent;