APPS.PO_AME_SETUP_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

  SELECT gls.currency_code
  INTO l_currency_code
  FROM financials_system_params_all fsp,
       gl_sets_of_books gls,
       po_requisition_headers_all prh
  WHERE fsp.set_of_books_id = gls.set_of_books_id and
        fsp.org_id = prh.org_id and       -- 
        prh.requisition_header_id = reqHeaderId;

Line: 74

    SELECT fu.user_id
    INTO l_user_id
    FROM fnd_user fu, po_requisition_headers_all prh
    WHERE prh.requisition_header_id = reqHeaderId and
          prh.preparer_id = fu.employee_id;

Line: 127

  cursor c1(l_distribution_id	in NUMBER) is SELECT code_combination_id, set_of_books_id
                FROM po_req_distributions_all
                WHERE distribution_id= l_distribution_id;

Line: 131

  cursor c2(l_distribution_id	in NUMBER) is SELECT code_combination_id, set_of_books_id
                FROM po_distributions_merge_v
                WHERE po_distribution_id= l_distribution_id;

Line: 149

  SELECT chart_of_accounts_id
  INTO l_chart_of_accounts_id
  FROM gl_sets_of_books
  WHERE set_of_books_id = l_sob;

Line: 224

  cursor c2(l_distribution_id	in NUMBER, l_draft_id in NUMBER) is SELECT code_combination_id, set_of_books_id
                FROM po_distributions_merge_v
                WHERE po_distribution_id= l_distribution_id
                AND draft_id = l_draft_id;

Line: 238

  SELECT chart_of_accounts_id
  INTO l_chart_of_accounts_id
  FROM gl_sets_of_books
  WHERE set_of_books_id = l_sob;

Line: 303

  select org_id
  into l_org_id
  from po_requisition_headers_all
  where requisition_header_id = ReqHeaderId;

Line: 312

  SELECT sum(po_calculatereqtotal_pvt.get_req_distribution_total(
              PORL.requisition_header_id,PORL.requisition_line_id,
              PORD.distribution_id))
  into l_req_total
  FROM
       PO_REQ_DISTRIBUTIONS_ALL PORD,  -- 
       PO_REQUISITION_LINES PORL
  WHERE  PORL.requisition_header_id = ReqHeaderId
         AND    PORL.requisition_line_id = PORD.requisition_line_id
         AND    nvl(PORL.cancel_flag, 'N') = 'N'
         AND    nvl(PORL.modified_by_agent_flag, 'N') = 'N';

Line: 358

  select segment1, org_id  into reqNumber, orgId
  from po_requisition_headers_all
  where requisition_header_id =  oldReqHeaderId;

Line: 365

    select requisition_header_id into newReqHeaderId
    from po_requisition_headers_all
    where segment1 = newReqNumber
      and org_id = orgId ;  -- 

Line: 427

    SELECT fu.user_id
    INTO l_user_id
    FROM fnd_user fu, po_requisition_headers_all prh
    WHERE prh.requisition_header_id = reqHeaderId and
          prh.preparer_id = fu.employee_id;

Line: 488

  SELECT NVL(pdt.can_preparer_approve_flag, 'N')
  INTO l_can_approve
  FROM po_document_types_all_b pdt, po_requisition_headers_all prh
  WHERE prh.requisition_header_id = reqHeaderId and
          pdt.org_id = prh.org_id and        -- 
          prh.type_lookup_code = pdt.document_subtype and
          pdt.DOCUMENT_TYPE_CODE='REQUISITION';

Line: 531

  SELECT NVL(pdt.can_preparer_approve_flag, 'N')
  INTO l_can_approve
  FROM po_document_types_all_b pdt, po_headers_merge_v phm
  WHERE phm.ame_approval_id = ameApprovalId and
          pdt.org_id = phm.org_id and        -- 
          phm.type_lookup_code = pdt.document_subtype and
          pdt.DOCUMENT_TYPE_CODE in ('PO','PA');

Line: 581

    SELECT fu.user_id
    INTO l_user_id
    FROM fnd_user fu, po_headers_merge_v phm
    WHERE phm.ame_approval_id = ameApprovalId and
          phm.agent_id = fu.employee_id;

Line: 627

  SELECT gls.currency_code
  INTO l_currency_code
  FROM financials_system_params_all fsp,
       gl_sets_of_books gls,
       po_headers_merge_v phm
  WHERE fsp.set_of_books_id = gls.set_of_books_id and
        fsp.org_id = phm.org_id and       -- 
        phm.ame_approval_id = ameApprovalId;

Line: 669

    SELECT fu.user_id
		    INTO l_user_id
		    FROM fnd_user fu, po_headers_merge_v phm
		    WHERE phm.ame_approval_id = ameApprovalId and
          phm.agent_id = fu.employee_id;

Line: 716

		select nvl(SUM(decode(plm.order_type_lookup_code, 'RATE', plm.amount, 'FIXED PRICE', plm.amount, plm.quantity * plm.unit_price)), 0)
			into l_original_amount
			from po_lines_all plm, po_headers_merge_v phm
			where plm.po_header_id = phm.po_header_id
			and phm.ame_approval_id = ameApprovalId;

Line: 727

			select nvl(SUM(decode(plm.order_type_lookup_code, 'RATE', plm.amount, 'FIXED PRICE', plm.amount, plm.quantity * plm.unit_price)), 0)
				into l_changed_amount
				from po_lines_merge_v plm,
						po_headers_merge_v phm
				where plm.po_header_id = phm.po_header_id
				and phm.draft_id = plm.draft_id
				and phm.ame_approval_id = ameApprovalId;

Line: 777

        select nvl(SUM(
                    ABS((decode(pld.order_type_lookup_code, 'RATE', pld.amount, 'FIXED PRICE', pld.amount, pld.quantity * pld.unit_price)) -
                        NVL((decode(pl.order_type_lookup_code, 'RATE', pl.amount, 'FIXED PRICE', pl.amount, pl.quantity * pl.unit_price)), 0) )
                      ), 0)
        into l_changed_amount
        from po_lines_draft_all pld, po_lines_all pl
        where pld.po_header_id = p_po_header_id
        and   pld.draft_id = p_draft_id
        and   pl.po_line_id(+) = pld.po_line_id;