APPS.GL_TRANS_TRACKING_PKG SQL Statements

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

Line: 16

                                 x_last_updated_by   NUMBER,
				 x_usage_code        VARCHAR2) IS
    bsv		VARCHAR2(25);

Line: 32

    UPDATE GL_TRANSLATION_TRACKING trtrk
       SET trtrk.FIRST_OUTDATED_EFF_PERIOD_NUM =
		 x_period_year * 10000 + x_period_num,
	   trtrk.FIRST_OUTDATED_PERIOD_NAME = x_period_name,
           trtrk.LAST_UPDATE_DATE = SYSDATE,
           trtrk.LAST_UPDATED_BY = x_last_updated_by
     WHERE trtrk.LEDGER_ID = x_ledger_id
       AND trtrk.BAL_SEG_VALUE = bsv
       AND trtrk.TARGET_CURRENCY= x_currency
       AND trtrk.AVERAGE_TRANSLATION_FLAG = 'Y'
       AND trtrk.ACTUAL_FLAG = 'A'
       AND trtrk.FIRST_OUTDATED_EFF_PERIOD_NUM >
           (x_period_year * 10000 + x_period_num);

Line: 53

                                 x_last_updated_by   ,
				 x_usage_code );