APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 1493: FROM po_headers_all PH, po_doc_style_headers PDSH

1489: -- CLM Controls Project changes
1490: -- Added Org_id in the query
1491: SELECT 'PURCHASING', PH.TYPE_LOOKUP_CODE, PH.STYLE_ID, nvl(PDSH.CLM_FLAG, 'N'), PH.ORG_ID
1492: INTO l_functional_area_code, l_document_type_code, l_document_style_id, l_is_clm_doc, l_org_id
1493: FROM po_headers_all PH, po_doc_style_headers PDSH
1494: WHERE PH.PO_HEADER_ID = l_document_id
1495: AND PH.style_id = PDSH.style_id;
1496:
1497: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');

Line 8271: po_doc_style_headers s

8267: -- CLM Aprvl
8268: Begin
8269: SELECT 'Y' into l_clm_document
8270: FROM po_headers_all h,
8271: po_doc_style_headers s
8272: WHERE h.po_header_id = p_document_id
8273: AND h.style_id = s.style_id
8274: AND Nvl(s.clm_flag,'N') = 'Y';
8275: Exception

Line 22193: FROM po_doc_style_headers pdsh,

22189: l_warrant_enabled_flag := 'N';
22190:
22191: SELECT 'Y'
22192: INTO l_warrant_enabled_flag
22193: FROM po_doc_style_headers pdsh,
22194: po_headers_all pha
22195: WHERE pha.po_header_id = p_header_id
22196: AND pha.style_id = pdsh.style_id
22197: AND pdsh.warrant_type is not NULL;

Line 22217: po_doc_style_headers pdsh,

22213: INTO l_warrant_amount, l_warrant_currency, l_doc_currency,
22214: l_type_lookup_code, l_rate
22215: FROM po_warrant_lines pwl,
22216: po_user_warrants puw,
22217: po_doc_style_headers pdsh,
22218: po_agents pa,
22219: po_headers_all phm
22220: WHERE phm.po_header_id = p_header_id
22221: AND phm.style_id = pdsh.style_id

Line 22245: po_doc_style_headers pdsh,

22241: INTO l_warrant_amount, l_warrant_currency, l_doc_currency,
22242: l_type_lookup_code, l_rate
22243: FROM po_warrant_lines pwl,
22244: po_user_warrants puw,
22245: po_doc_style_headers pdsh,
22246: po_agents pa,
22247: po_headers_all phm
22248: WHERE phm.po_header_id = p_header_id
22249: AND phm.style_id = pdsh.style_id

Line 23058: po_doc_style_headers PDSH

23054: SELECT 'Y'
23055: INTO l_is_approved_clm_document
23056: FROM po_headers_gt POH1,
23057: po_headers_all POH,
23058: po_doc_style_headers PDSH
23059: WHERE POH1.po_header_id = p_document_id
23060: AND POH1.po_header_id = POH.po_header_id
23061: AND POH.style_id = PDSH.style_id
23062: AND Nvl(PDSH.clm_flag,'N') = 'Y'