DBA Data[Home] [Help]

APPS.GL_TRANS_DATES_PKG SQL Statements

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

Line: 38

 SELECT
	to_char(sum(decode(business_day_flag, 'Y', 1, 'N', 2) *
  	            power(10, transaction_date - X_start_date)))
 FROM
       	GL_TRANSACTION_DATES
 WHERE
	transaction_calendar_id = X_transaction_cal_id
    AND transaction_date between X_start_date and X_end_date;