DBA Data[Home] [Help]

APPS.GL_AUTOREVERSE_DATE_PKG dependencies on GL_TRANSACTION_DATES

Line 22: FROM gl_transaction_dates

18: WHERE je_source_name = X_Je_Source;
19:
20: CURSOR is_business_day IS
21: SELECT business_day_flag
22: FROM gl_transaction_dates
23: WHERE transaction_calendar_id = X_Trxn_Calendar_Id
24: AND transaction_date = X_Reversal_Date;
25:
26: CURSOR roll_backward IS

Line 28: FROM gl_transaction_dates

24: AND transaction_date = X_Reversal_Date;
25:
26: CURSOR roll_backward IS
27: SELECT max(transaction_date)
28: FROM gl_transaction_dates
29: WHERE transaction_calendar_id = X_Trxn_Calendar_Id
30: AND business_day_flag = 'Y'
31: AND transaction_date <= X_Reversal_Date;
32:

Line 35: FROM gl_transaction_dates

31: AND transaction_date <= X_Reversal_Date;
32:
33: CURSOR roll_forward IS
34: SELECT min(transaction_date)
35: FROM gl_transaction_dates
36: WHERE transaction_calendar_id = X_Trxn_Calendar_Id
37: AND business_day_flag = 'Y'
38: AND transaction_date >= X_Reversal_Date;
39: