eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_ADJVALIDATE_PVT dependencies on GL_PERIOD_STATUSES

Line 70: start_date gl_period_statuses.start_date%type,

66:
67:
68: TYPE Glperiod_Rec_Type IS RECORD
69: (
70: start_date gl_period_statuses.start_date%type,
71: end_date gl_period_statuses.end_date%type
72: ) ;
73: TYPE Glperiod_Cache_Tbl_Type IS
74: TABLE OF GLperiod_Rec_Type

Line 71: end_date gl_period_statuses.end_date%type

67:
68: TYPE Glperiod_Rec_Type IS RECORD
69: (
70: start_date gl_period_statuses.start_date%type,
71: end_date gl_period_statuses.end_date%type
72: ) ;
73: TYPE Glperiod_Cache_Tbl_Type IS
74: TABLE OF GLperiod_Rec_Type
75: INDEX BY BINARY_INTEGER;

Line 231: FROM gl_period_statuses g,

227:
228: CURSOR l_periods_csr IS
229: SELECT trunc(g.start_date) start_date,
230: trunc(g.end_date) end_date
231: FROM gl_period_statuses g,
232: gl_sets_of_books b
233: WHERE g.application_id = 222
234: AND g.set_of_books_id = l_set_of_books_id
235: AND g.set_of_books_id = b.set_of_books_id

Line 2660: FROM gl_period_statuses g,

2656: l_count := 0 ;
2657:
2658: SELECT count(*)
2659: INTO l_count
2660: FROM gl_period_statuses g,
2661: gl_sets_of_books b
2662: WHERE g.application_id = 222
2663: AND g.set_of_books_id = l_set_of_books_id
2664: AND g.set_of_books_id = b.set_of_books_id