APPS.AR_ADJVALIDATE_PUB dependencies on GL_PERIOD_STATUSES

Line 60: start_date gl_period_statuses.start_date%type,

56:
57:
58: TYPE Glperiod_Rec_Type IS RECORD
59: (
60: start_date gl_period_statuses.start_date%type,
61: end_date gl_period_statuses.end_date%type
62: ) ;
63: TYPE Glperiod_Cache_Tbl_Type IS
64: TABLE OF GLperiod_Rec_Type

Line 61: end_date gl_period_statuses.end_date%type

57:
58: TYPE Glperiod_Rec_Type IS RECORD
59: (
60: start_date gl_period_statuses.start_date%type,
61: end_date gl_period_statuses.end_date%type
62: ) ;
63: TYPE Glperiod_Cache_Tbl_Type IS
64: TABLE OF GLperiod_Rec_Type
65: INDEX BY BINARY_INTEGER;

Line 291: FROM gl_period_statuses g,

287:
288: CURSOR l_periods_csr IS
289: SELECT trunc(g.start_date) start_date,
290: trunc(g.end_date) end_date
291: FROM gl_period_statuses g,
292: gl_sets_of_books b
293: WHERE g.application_id = 222
294: AND g.set_of_books_id = l_set_of_books_id
295: AND g.set_of_books_id = b.set_of_books_id

Line 2209: FROM gl_period_statuses g,

2205: l_count := 0 ;
2206:
2207: SELECT count(*)
2208: INTO l_count
2209: FROM gl_period_statuses g,
2210: gl_sets_of_books b
2211: WHERE g.application_id = 222
2212: AND g.set_of_books_id = l_set_of_books_id
2213: AND g.set_of_books_id = b.set_of_books_id