APPS.GL_SRS_INCREMENTOR_API dependencies on GL_TRANSACTION_DATES

Line 33: FROM gl_transaction_dates

29: v_new_anchor_date DATE := TRUNC(x_new_anchor_date);
30:
31: CURSOR get_future_date IS
32: SELECT transaction_date
33: FROM gl_transaction_dates
34: WHERE transaction_calendar_id = v_trxn_calendar_id
35: AND business_day_flag = 'Y'
36: AND transaction_date > v_new_anchor_date
37: ORDER BY transaction_date ASC;

Line 41: FROM gl_transaction_dates

37: ORDER BY transaction_date ASC;
38:
39: CURSOR get_past_date IS
40: SELECT transaction_date
41: FROM gl_transaction_dates
42: WHERE transaction_calendar_id = v_trxn_calendar_id
43: AND business_day_flag = 'Y'
44: AND transaction_date < v_new_anchor_date
45: ORDER BY transaction_date DESC;

Line 49: FROM gl_transaction_dates

45: ORDER BY transaction_date DESC;
46:
47: CURSOR get_bus_day_flag IS
48: SELECT business_day_flag
49: FROM gl_transaction_dates
50: WHERE transaction_calendar_id = v_trxn_calendar_id
51: AND transaction_date = CURRENT_DATE;
52: BEGIN
53: --dbms_output.put_line('x_last_anchor_date = '||to_char(V_Last_Anchor_Date));

Line 98: FROM gl_transaction_dates

94: error_code := -21;
95:
96: SELECT COUNT(*)
97: INTO days_offset
98: FROM gl_transaction_dates
99: WHERE transaction_calendar_id = v_trxn_calendar_id
100: AND business_day_flag = 'Y'
101: AND transaction_date >= v_last_para_date
102: AND transaction_date < v_last_anchor_date;

Line 123: FROM gl_transaction_dates

119: error_code := -23;
120:
121: SELECT COUNT(*)
122: INTO days_offset
123: FROM gl_transaction_dates
124: WHERE transaction_calendar_id = v_trxn_calendar_id
125: AND business_day_flag = 'Y'
126: AND transaction_date > v_last_anchor_date
127: AND transaction_date <= v_last_para_date;