APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 1165: okc_bus_doc_types_b busDocTypes,

1161: AND del.recurring_del_parent_id is NULL
1162: AND (del.amendment_operation is NULL OR del.amendment_operation <> 'DELETED')
1163: AND (del.summary_amend_operation_code is NULL OR del.summary_amend_operation_code <> 'DELETED')
1164: AND del.deliverable_type in (select delTypes.deliverable_type_code from
1165: okc_bus_doc_types_b busDocTypes,
1166: okc_del_bus_doc_combxns delTypes
1167: WHERE busDocTypes.document_type = del.business_document_type
1168: AND delTypes.document_type_class = busDocTypes.document_type_class
1169: AND del.deliverable_type = delTypes.deliverable_type_code)

Line 2049: from okc_bus_doc_types_b bd,

2045: OR
2046: (recurring_YN = 'Y'
2047: AND recurring_del_parent_id is null
2048: AND del.deliverable_type in ( select d.deliverable_type_code
2049: from okc_bus_doc_types_b bd,
2050: okc_del_bus_doc_combxns d
2051: WHERE bd.document_type = del.business_document_type
2052: AND d.document_type_class = bd.document_type_class
2053: AND del.deliverable_type = d.deliverable_type_code ))

Line 3844: from okc_bus_doc_types_b

3840: SELECT deliverable_id,external_party_site_id
3841: FROM okc_deliverables
3842: where external_party_id = p_from_external_party_id
3843: and business_document_type IN (select document_type
3844: from okc_bus_doc_types_b
3845: where document_type_class = p_document_class);
3846: del_rec del_cur%ROWTYPE;
3847:
3848: TYPE delIdTabType IS TABLE OF NUMBER

Line 4411: from okc_bus_doc_types_b

4407: FROM okc_deliverables
4408: where external_party_id = NVL(p_from_external_party_id,external_party_id)
4409: and external_party_role <> 'SUPPLIER_ORG'
4410: and business_document_type IN (select document_type
4411: from okc_bus_doc_types_b
4412: where document_type_class = p_document_class);
4413: del_rec del_cur%ROWTYPE;
4414:
4415: TYPE delIdTabType IS TABLE OF NUMBER