APPS.PO_AME_SETUP_PVT dependencies on PO_HEADERS_MERGE_V

Line 533: FROM po_document_types_all_b pdt, po_headers_merge_v phm

529:
530: BEGIN
531: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
532: INTO l_can_approve
533: FROM po_document_types_all_b pdt, po_headers_merge_v phm
534: WHERE phm.ame_approval_id = ameApprovalId and
535: pdt.org_id = phm.org_id and --
536: phm.type_lookup_code = pdt.document_subtype and
537: pdt.DOCUMENT_TYPE_CODE in ('PO','PA');

Line 583: FROM fnd_user fu, po_headers_merge_v phm

579:
580: BEGIN
581: SELECT fu.user_id
582: INTO l_user_id
583: FROM fnd_user fu, po_headers_merge_v phm
584: WHERE phm.ame_approval_id = ameApprovalId and
585: phm.agent_id = fu.employee_id;
586: EXCEPTION
587: when others then

Line 631: po_headers_merge_v phm

627: SELECT gls.currency_code
628: INTO l_currency_code
629: FROM financials_system_params_all fsp,
630: gl_sets_of_books gls,
631: po_headers_merge_v phm
632: WHERE fsp.set_of_books_id = gls.set_of_books_id and
633: fsp.org_id = phm.org_id and --
634: phm.ame_approval_id = ameApprovalId;
635: RETURN l_currency_code;

Line 671: FROM fnd_user fu, po_headers_merge_v phm

667: BEGIN
668: BEGIN
669: SELECT fu.user_id
670: INTO l_user_id
671: FROM fnd_user fu, po_headers_merge_v phm
672: WHERE phm.ame_approval_id = ameApprovalId and
673: phm.agent_id = fu.employee_id;
674: EXCEPTION
675: when others then

Line 718: from po_lines_all plm, po_headers_merge_v phm

714: BEGIN
715: BEGIN
716: select nvl(SUM(decode(plm.order_type_lookup_code, 'RATE', plm.amount, 'FIXED PRICE', plm.amount, plm.quantity * plm.unit_price)), 0)
717: into l_original_amount
718: from po_lines_all plm, po_headers_merge_v phm
719: where plm.po_header_id = phm.po_header_id
720: and phm.ame_approval_id = ameApprovalId;
721: EXCEPTION
722: WHEN no_data_found THEN

Line 730: po_headers_merge_v phm

726: BEGIN
727: select nvl(SUM(decode(plm.order_type_lookup_code, 'RATE', plm.amount, 'FIXED PRICE', plm.amount, plm.quantity * plm.unit_price)), 0)
728: into l_changed_amount
729: from po_lines_merge_v plm,
730: po_headers_merge_v phm
731: where plm.po_header_id = phm.po_header_id
732: and phm.draft_id = plm.draft_id
733: and phm.ame_approval_id = ameApprovalId;
734: