DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_BUS_DOC_TYPES_TL

Line 40: FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable

36: deliverable.business_document_number,
37: deliverable.deliverable_name,
38: deliverable.notify_prior_due_date_value,
39: deliverable.notify_prior_due_date_uom
40: FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable
41: WHERE deliverable.deliverable_id = l_del_id
42: AND deliverable.business_document_type = busDocTL.document_type
43: AND busDocTL.language = userenv('LANG');
44: del_tokens_rec deliverable_tokens_cursor%ROWTYPE;

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;