APPS.GL_DAILY_BALANCES_PKG SQL Statements

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

Line: 14

                                 x_last_updated_by   NUMBER,
				 x_chart_of_accounts_id NUMBER,
				 x_period_name       VARCHAR2,
				 x_usage_code        VARCHAR2) IS
  BEGIN

    UPDATE GL_DAILY_BALANCES bal
       SET bal.CURRENCY_TYPE = 'O',
           bal.LAST_UPDATE_DATE = SYSDATE,
           bal.LAST_UPDATED_BY = x_last_updated_by
     WHERE bal.CURRENCY_TYPE = 'T'
       AND bal.LEDGER_ID = x_ledger_id
       AND bal.ACTUAL_FLAG = 'A'
       AND bal.TEMPLATE_ID IS NULL
       AND bal.CODE_COMBINATION_ID = x_ccid
       AND bal.CURRENCY_CODE = x_currency
       AND (bal.PERIOD_YEAR * 1000 + bal.PERIOD_NUM) >=
           (x_period_year * 1000 + x_period_num);

Line: 40

		      x_last_updated_by,
		      x_usage_code);