APPS.GMF_RA_GET_FOB_CODES SQL Statements

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

Line: 8

     SELECT    lookup_code,
        description,
        creation_date,
        created_by,
        last_update_date,
        last_updated_by,
	inactive_date
    FROM  po_lookup_codes
    WHERE   lookup_type = 'FOB'  AND
      lookup_code like lookupcode AND
      last_update_date  BETWEEN
        nvl(startdate,last_update_date)  AND
        nvl(enddate,last_update_date);

Line: 25

        select user_name into usr_name from fnd_user where
        user_id=usr_id;

Line: 38

      last_update_date out varchar2,
      last_updated_by out number,
      row_to_fetch in out number,
      statuscode out number,
      inactive_status out number) is
/*  ad_by  number;*/

Line: 56

      last_update_date,
      last_updated_by,
      inactive_date;