DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_PVT dependencies on DUAL

Line 635: FROM dual;

631:
632: -- Generate new ame_approval_id from sequence
633: SELECT po_ame_approvals_s.nextval
634: INTO l_ame_approval_id
635: FROM dual;
636:
637: SELECT mod_ame_transaction_type
638: INTO l_ame_transaction_type
639: FROM po_doc_style_headers

Line 2631: FROM dual

2627: BEGIN
2628: --check if mod already exists.
2629: SELECT 'Y'
2630: INTO l_mod_exists
2631: FROM dual
2632: WHERE EXISTS (SELECT 'Mod Exists'
2633: FROM po_drafts
2634: WHERE document_id = p_po_header_id
2635: AND status IN ('DRAFT', 'IN PROCESS', 'REJECTED', 'SUPPLIER SIGN', 'PRE-APPROVED'));