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 2240: FROM gl_period_statuses g,

2236: l_count := 0 ;
2237:
2238: SELECT count(*)
2239: INTO l_count
2240: FROM gl_period_statuses g,
2241: gl_sets_of_books b
2242: WHERE g.application_id = 222
2243: AND g.set_of_books_id = l_set_of_books_id
2244: AND g.set_of_books_id = b.set_of_books_id