DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on PO_ALL_DOC_STYLE_LINES

Line 5019: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl

5015: BEGIN
5016: --Bug 16801033
5017: IF(l_doctype_id<>rfi_doctype_id) THEN
5018: SELECT pdl.DOCUMENT_SUBTYPE, pdh.style_id INTO l_contract_type, l_po_style_id
5019: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl
5020: WHERE pdh.style_id = pdl.style_id
5021: AND pdh.status= 'ACTIVE'
5022: AND pdl.enabled_flag= 'Y'
5023: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP

Line 6685: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl

6681: print_log('init_rule_based_header_data: Document not RFI ');
6682:
6683: SELECT pdl.DOCUMENT_SUBTYPE, pdh.style_id
6684: INTO neg_header_record_data.contract_type, neg_header_record_data.po_style_id
6685: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl
6686: WHERE pdh.style_id = pdl.style_id
6687: AND pdh.status= 'ACTIVE'
6688: AND pdl.enabled_flag= 'Y'
6689: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP