APPS.ARP_AUTO_RULE dependencies on GL_PERIOD_STATUSES

Line 11: gl_period_statuses.start_date%TYPE

7:
8: /* GLOBAL declarations */
9:
10: TYPE gl_start_table_type IS TABLE OF
11: gl_period_statuses.start_date%TYPE
12: INDEX BY BINARY_INTEGER;
13:
14: gl_start_t gl_start_table_type;
15:

Line 17: gl_period_statuses.end_date%TYPE

13:
14: gl_start_t gl_start_table_type;
15:
16: TYPE gl_end_table_type IS TABLE OF
17: gl_period_statuses.end_date%TYPE
18: INDEX BY BINARY_INTEGER;
19:
20: gl_end_t gl_end_table_type;
21:

Line 23: gl_period_statuses.closing_status%TYPE

19:
20: gl_end_t gl_end_table_type;
21:
22: TYPE gl_status_table_type IS TABLE OF
23: gl_period_statuses.closing_status%TYPE
24: INDEX BY BINARY_INTEGER;
25:
26: gl_status_t gl_status_table_type;
27:

Line 29: gl_period_statuses.start_date%TYPE

25:
26: gl_status_t gl_status_table_type;
27:
28: TYPE gl_bump_table_type IS TABLE OF
29: gl_period_statuses.start_date%TYPE
30: INDEX BY BINARY_INTEGER;
31:
32: gl_bump_t gl_bump_table_type;
33:

Line 242: gl_period_statuses

238: start_date,
239: end_date,
240: closing_status
241: FROM
242: gl_period_statuses
243: WHERE
244: application_id = v_appl_id
245: AND set_of_books_id = v_sob
246: AND adjustment_period_flag = 'N'

Line 259: arp_standard.debug('Populating gl_period_statuses table.');

255: BEGIN
256: IF PG_DEBUG in ('Y', 'C') THEN
257: arp_standard.debug('arp_auto_rule.populate_glp_table()+ ' ||
258: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
259: arp_standard.debug('Populating gl_period_statuses table.');
260: END IF;
261:
262: /* Bug 2133254 - only call this the first time in for a given SOB */
263: /* Bug 3879222 - moved this logic inside the procedure */