APPS.GL_TRANS_STATUSES_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_STATUSES TS
       SET TS.status  		= 'U',
           TS.LAST_UPDATE_DATE  = sysdate,
           TS.LAST_UPDATED_BY   = x_last_updated_by
     WHERE TS.LEDGER_ID                = x_ledger_id
       AND TS.BAL_SEG_VALUE            = bsv
       AND TS.TARGET_CURRENCY          = x_currency
       AND TS.AVERAGE_TRANSLATION_FLAG = decode(x_usage_code, 'A', 'Y', 'N')
       AND TS.ACTUAL_FLAG              = 'A'
       AND TS.period_name IN
	   ( SELECT PS.period_name
	     FROM   GL_PERIOD_STATUSES PS
	     WHERE  PS.application_id       = 101
	     AND    PS.ledger_id      = x_ledger_id
	     AND    PS.effective_period_num >=
                    (x_period_year * 10000 + x_period_num));