APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_BUS_DOC_TYPES_B

Line 292: FROM okc_bus_doc_types_b b, okc_bus_doc_types_tl tl

288:
289: CURSOR BUSDOC_TYPE IS
290: SELECT tl.name,b.document_type_class,
291: b.external_userlist_proc,b.notification_header_function
292: FROM okc_bus_doc_types_b b, okc_bus_doc_types_tl tl
293: WHERE b.document_type = tl.document_type
294: AND tl.language = userenv('LANG')
295: AND b.document_type = p_business_document_type;
296: busdoc_type_rec busdoc_type%ROWTYPE;

Line 309: okc_bus_doc_types_b docType,

305: -- updated cursor for bug#4069955
306: CURSOR delTypeInternalFlag is
307: select delType.internal_flag
308: from okc_deliverable_types_b delType,
309: okc_bus_doc_types_b docType,
310: okc_del_bus_doc_combxns delComb
311: where delType.deliverable_type_code = p_deliverable_type
312: and docType.document_type = p_business_document_type
313: and docType.document_type_class = delComb.document_type_class

Line 322: ,okc_bus_doc_types_b docType

318: CURSOR getRespPartyCode IS
319: select resp_party_code
320: from
321: okc_resp_parties_b delrsp
322: ,okc_bus_doc_types_b docType
323: where delrsp.resp_party_code = p_resp_party
324: and doctype.document_type = p_business_document_type
325: and delrsp.document_type_class = docType.document_type_class
326: and delrsp.intent = docType.intent;