APPS.PO_COPYDOC_S1 dependencies on PO_DOC_STYLE_HEADERS

Line 495: FROM po_doc_style_headers podsh

491: AND nvl(x_po_header_record.global_agreement_flag,'N') = 'Y')) THEN
492: BEGIN
493: SELECT po_ame_approvals_s.NEXTVAL, ame_transaction_type
494: INTO l_ame_approval_id, l_ame_transaction_type
495: FROM po_doc_style_headers podsh
496: WHERE podsh.style_id= x_po_header_record.style_id
497: AND podsh.ame_transaction_type IS NOT NULL;
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN

Line 3951: FROM po_doc_style_headers

3947: IF l_is_complex_work_po THEN
3948:
3949: SELECT Nvl(contract_financing_flag,'N')
3950: INTO l_is_complex_finance_po
3951: FROM po_doc_style_headers
3952: WHERE style_id = (SELECT style_id FROM po_headers_all WHERE po_header_id = x_from_po_header_id);
3953:
3954:
3955: IF( l_is_complex_finance_po LIKE 'Y' AND x_po_shipment_record.shipment_type LIKE 'STANDARD') THEN