DBA Data[Home] [Help]

APPS.GL_TRANSACTION_DATES_PKG dependencies on GL_ROW_MULTIPLIERS

Line 113: FROM gl_transaction_calendar tcal, gl_row_multipliers cnt

109: x_CREATED_BY,
110: x_LAST_UPDATE_DATE,
111: x_LAST_UPDATED_BY,
112: x_LAST_UPDATE_LOGIN
113: FROM gl_transaction_calendar tcal, gl_row_multipliers cnt
114: WHERE
115: cnt.multiplier <= TO_DATE(new_entered_year || '/12/31', 'YYYY/MM/DD') -
116: TO_DATE(new_entered_year || '/01/01', 'YYYY/MM/DD')+1
117: AND NOT EXISTS

Line 229: FROM gl_transaction_calendar cal, gl_row_multipliers yr, gl_row_multipliers cnt

225: x_CREATED_BY,
226: x_LAST_UPDATE_DATE,
227: x_LAST_UPDATED_BY,
228: x_LAST_UPDATE_LOGIN
229: FROM gl_transaction_calendar cal, gl_row_multipliers yr, gl_row_multipliers cnt
230: WHERE
231: cal.transaction_calendar_id = x_transaction_calendar_id
232: AND cnt.multiplier <= TO_DATE(TO_CHAR(yr.multiplier+1900) || '/12/31', 'YYYY/MM/DD') -
233: TO_DATE(TO_CHAR(yr.multiplier+1900) || '/01/01', 'YYYY/MM/DD')+1