DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 534: FROM po_doc_style_headers pdsh, po_headers_all pha

530: END IF;
531:
532: SELECT mod_ame_transaction_type
533: INTO l_ame_transaction_type
534: FROM po_doc_style_headers pdsh, po_headers_all pha
535: WHERE pha.po_header_id = l_doc_row.po_header_id
536: AND pha.style_id = pdsh.style_id;
537:
538: --

Line 847: FROM po_doc_style_headers pdsh, po_headers_all pha

843:
844:
845: SELECT pdsh.ame_transaction_type
846: INTO l_ame_transaction_type
847: FROM po_doc_style_headers pdsh, po_headers_all pha
848: WHERE pha.po_header_id = l_doc_row.po_header_id
849: AND pha.style_id = pdsh.style_id;
850:
851: UPDATE po_headers_draft_all

Line 1714: FROM po_headers_all poh, po_doc_style_headers pdsh

1710: END IF;
1711:
1712: SELECT 'N'
1713: INTO x_create_doc_flag
1714: FROM po_headers_all poh, po_doc_style_headers pdsh
1715: WHERE poh.po_header_id = p_po_header_id
1716: AND poh.style_id = pdsh.style_id
1717: AND poh.approved_flag = 'Y'
1718: AND pdsh.change_process_type = 'MODIFICATION';