DBA Data[Home] [Help]

APPS.GML_POAPPSRS_XMLP_PKG SQL Statements

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

Line: 68

	SELECT RECV_NO
	INTO V_RECV_NO
  FROM   PO_RECV_HDR
  WHERE RECV_ID = P_RECV_NO_FROM;
Line: 83

	SELECT RECV_NO
	INTO V_RECV_NO
  FROM   PO_RECV_HDR
  WHERE RECV_ID = P_RECV_NO_TO;
Line: 98

	SELECT PO_NO
	INTO V_PO_NO
  FROM   PO_ORDR_HDR
  WHERE PO_ID = P_PO_NO_FROM;
Line: 114

	SELECT PO_NO
	INTO V_PO_NO
  FROM   PO_ORDR_HDR
  WHERE PO_ID = P_PO_NO_TO;