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 1460: okc_del_bus_doc_combxns bdc

1456: /*
1457: CURSOR delType_cur IS
1458: select 'Y'
1459: FROM okc_bus_doc_types_b docType,
1460: okc_del_bus_doc_combxns bdc
1461: WHERE docType.document_type_class = bdc.document_type_class
1462: AND docType.document_type = p_busdoc_type
1463: and bdc.deliverable_type = p_del_type;
1464: */

Line 1471: ,okc_del_bus_doc_combxns deltyp

1467: CURSOR delType_cur IS
1468: select 'Y'
1469: FROM
1470: okc_bus_doc_types_b doctyp
1471: ,okc_del_bus_doc_combxns deltyp
1472: where
1473: doctyp.document_type_class = deltyp.document_type_class
1474: AND doctyp.document_type = p_busdoc_type
1475: AND deltyp.deliverable_type_code = p_del_type;

Line 9894: --okc_del_bus_doc_combxns deltypes

9890: where business_document_type = p_doc_type
9891: and business_document_id = p_doc_id
9892: and business_document_version = -99
9893: and deliverable_type in (select deltypes.deliverable_type_code from okc_bus_doc_types_b doctypes,
9894: --okc_del_bus_doc_combxns deltypes
9895: okc_deliverable_types_b deltypes
9896: where doctypes.document_type=p_doc_type
9897: and doctypes.document_type_class = deltypes.document_type_class)
9898: and amendment_operation is not null;

Line 9925: okc_del_bus_doc_combxns deltypes

9921: and (amendment_operation is NULL OR amendment_operation <> 'DELETED')
9922: and (summary_amend_operation_code is NULL OR summary_amend_operation_code <> 'DELETED')
9923: and deliverable_type in (select deltypes.deliverable_type_code
9924: from okc_bus_doc_types_b doctypes,
9925: okc_del_bus_doc_combxns deltypes
9926: where doctypes.document_type=p_doc_type
9927: and doctypes.document_type_class = deltypes.document_type_class);
9928:
9929: