APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 1089: okc_bus_doc_types_b busDocTypes,

1085: AND del.recurring_del_parent_id is NULL
1086: AND (del.amendment_operation is NULL OR del.amendment_operation <> 'DELETED')
1087: AND (del.summary_amend_operation_code is NULL OR del.summary_amend_operation_code <> 'DELETED')
1088: AND del.deliverable_type in (select delTypes.deliverable_type_code from
1089: okc_bus_doc_types_b busDocTypes,
1090: okc_del_bus_doc_combxns delTypes
1091: WHERE busDocTypes.document_type = del.business_document_type
1092: AND delTypes.document_type_class = busDocTypes.document_type_class
1093: AND del.deliverable_type = delTypes.deliverable_type_code)

Line 1946: from okc_bus_doc_types_b bd,

1942: OR
1943: (recurring_YN = 'Y'
1944: AND recurring_del_parent_id is null
1945: AND del.deliverable_type in ( select d.deliverable_type_code
1946: from okc_bus_doc_types_b bd,
1947: okc_del_bus_doc_combxns d
1948: WHERE bd.document_type = del.business_document_type
1949: AND d.document_type_class = bd.document_type_class
1950: AND del.deliverable_type = d.deliverable_type_code ))

Line 3724: from okc_bus_doc_types_b

3720: SELECT deliverable_id,external_party_site_id
3721: FROM okc_deliverables
3722: where external_party_id = p_from_external_party_id
3723: and business_document_type IN (select document_type
3724: from okc_bus_doc_types_b
3725: where document_type_class = p_document_class);
3726: del_rec del_cur%ROWTYPE;
3727:
3728: TYPE delIdTabType IS TABLE OF NUMBER

Line 4266: from okc_bus_doc_types_b

4262: FROM okc_deliverables
4263: where external_party_id = NVL(p_from_external_party_id,external_party_id)
4264: and external_party_role <> 'SUPPLIER_ORG'
4265: and business_document_type IN (select document_type
4266: from okc_bus_doc_types_b
4267: where document_type_class = p_document_class);
4268: del_rec del_cur%ROWTYPE;
4269:
4270: TYPE delIdTabType IS TABLE OF NUMBER