DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_BUS_DOC_TYPES_TL

Line 41: FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable

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

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;