APPS.PO_REQS_SV2 SQL Statements

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

Line: 22

	select distinct polc.DISPLAYED_FIELD,  porh.AUTHORIZATION_STATUS
	INTO   X_req_header_auth_status_dsp, X_req_header_auth_status
	from PO_LOOKUP_CODES polc, PO_REQUISITION_HEADERS_ALL porh
	where
	porh.authorization_status = polc.LOOKUP_CODE
	and polc.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
	and porh.requisition_header_id = X_req_header_id;

Line: 30

/*       SELECT authorization_status
       INTO   X_req_header_auth_status
       FROM   PO_REQUISITION_HEADERS
       WHERE  requisition_header_id = X_req_header_id;