APPS.AR_ADJVALIDATE_PUB dependencies on AR_SYSTEM_PARAMETERS

Line 286: l_set_of_books_id ar_system_parameters.set_of_books_id%type;

282:
283: PROCEDURE Cache_Gl_Periods (p_return_status IN OUT NOCOPY VARCHAR2 )
284: IS
285:
286: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
287:
288: CURSOR l_periods_csr IS
289: SELECT trunc(g.start_date) start_date,
290: trunc(g.end_date) end_date

Line 314: FROM ar_system_parameters ;

310: p_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: SELECT set_of_books_id
313: INTO l_set_of_books_id
314: FROM ar_system_parameters ;
315:
316: l_index := 0 ;
317: FOR l_temp_rec IN l_periods_csr LOOP
318: l_index := l_index + 1;

Line 2166: l_set_of_books_id AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE ;

2162:
2163: l_index number;
2164: l_found_flag BOOLEAN;
2165: l_count number ;
2166: l_set_of_books_id AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE ;
2167:
2168: BEGIN
2169:
2170: IF PG_DEBUG in ('Y', 'C') THEN

Line 2234: from ar_system_parameters;

2230: THEN
2231:
2232: select set_of_books_id
2233: into l_set_of_books_id
2234: from ar_system_parameters;
2235:
2236: l_count := 0 ;
2237:
2238: SELECT count(*)