APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DEL_BUS_DOC_COMBXNS

Line 32: okc_del_bus_doc_combxns deltypcomb

28: x_doc_type VARCHAR2) is
29: SELECT 'X'
30: FROM
31: okc_bus_doc_types_b doctyp,
32: okc_del_bus_doc_combxns deltypcomb
33: WHERE
34: doctyp.document_type_class = deltypcomb.document_type_class
35: AND doctyp.document_type = x_doc_type
36: AND deltypcomb.deliverable_type_code = x_deliverable_type;

Line 118: okc_del_bus_doc_combxns deltypcomb

114: x_doc_type VARCHAR2) is
115: SELECT 'X'
116: FROM
117: okc_bus_doc_types_b doctyp,
118: okc_del_bus_doc_combxns deltypcomb
119: WHERE
120: doctyp.document_type_class = deltypcomb.document_type_class
121: AND doctyp.document_type = x_doc_type
122: AND deltypcomb.deliverable_type_code = x_deliverable_type;

Line 363: okc_del_bus_doc_combxns delComb

359: -- updated cursor for bug#4069955
360: CURSOR getDelTypeIntFlag IS
361: select delTyp.internal_flag
362: from okc_deliverable_types_b delTyp,
363: okc_del_bus_doc_combxns delComb
364: where delTyp.deliverable_type_code = p_deliverable_type
365: and delComb.deliverable_type_code = delTyp.deliverable_type_code
366: and delComb.document_type_class = p_document_type_class;
367:

Line 1378: okc_del_bus_doc_combxns bdc

1374: /*
1375: CURSOR delType_cur IS
1376: select 'Y'
1377: FROM okc_bus_doc_types_b docType,
1378: okc_del_bus_doc_combxns bdc
1379: WHERE docType.document_type_class = bdc.document_type_class
1380: AND docType.document_type = p_busdoc_type
1381: and bdc.deliverable_type = p_del_type;
1382: */

Line 1389: ,okc_del_bus_doc_combxns deltyp

1385: CURSOR delType_cur IS
1386: select 'Y'
1387: FROM
1388: okc_bus_doc_types_b doctyp
1389: ,okc_del_bus_doc_combxns deltyp
1390: where
1391: doctyp.document_type_class = deltyp.document_type_class
1392: AND doctyp.document_type = p_busdoc_type
1393: AND deltyp.deliverable_type_code = p_del_type;

Line 9068: --okc_del_bus_doc_combxns deltypes

9064: where business_document_type = p_doc_type
9065: and business_document_id = p_doc_id
9066: and business_document_version = -99
9067: and deliverable_type in (select deltypes.deliverable_type_code from okc_bus_doc_types_b doctypes,
9068: --okc_del_bus_doc_combxns deltypes
9069: okc_deliverable_types_b deltypes
9070: where doctypes.document_type=p_doc_type
9071: and doctypes.document_type_class = deltypes.document_type_class)
9072: and amendment_operation is not null;

Line 9096: okc_del_bus_doc_combxns deltypes

9092: and (amendment_operation is NULL OR amendment_operation <> 'DELETED')
9093: and (summary_amend_operation_code is NULL OR summary_amend_operation_code <> 'DELETED')
9094: and deliverable_type in (select deltypes.deliverable_type_code
9095: from okc_bus_doc_types_b doctypes,
9096: okc_del_bus_doc_combxns deltypes
9097: where doctypes.document_type=p_doc_type
9098: and doctypes.document_type_class = deltypes.document_type_class);
9099:
9100: