APPS.PO_AGENTS_SV1 SQL Statements

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

Line: 20

  /* get the agent_id by selecting employee_id from po_buyers_val_v
     based on the agent_name provided from input parameter */

  SELECT	 employee_id
  INTO		 X_agent_id_v
  FROM		 po_buyers_val_v
  WHERE		 full_name = X_agent_name;

Line: 57

   SELECT count(*)
     INTO x_temp
     FROM po_buyers_val_v
    WHERE employee_id  = X_agent_id;