DBA Data[Home] [Help]

APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on OKC_DEL_BUS_DOC_COMBXNS

Line 1090: okc_del_bus_doc_combxns delTypes

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)
1094: AND (G_FALSE = p_cancel_flag OR ( del.RELATIVE_ST_DATE_EVENT_ID in

Line 1947: okc_del_bus_doc_combxns d

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 ))
1951: );