APPS.PA_RESOURCE_UTILS dependencies on GL_PERIODS

Line 2190: from gl_periods glp,

2186:
2187: IF (p_period_type = 'GL') THEN
2188:
2189: select glp.end_date into l_date
2190: from gl_periods glp,
2191: gl_sets_of_books glsob,
2192: pa_implementations pai
2193: where pai.set_of_books_id = glsob.set_of_books_id
2194: and glsob.period_set_name = glp.period_set_name

Line 2228: from gl_periods glp,

2224: ELSIF (p_period_type = 'YR') THEN
2225:
2226: select max(glp.end_date)
2227: into l_date
2228: from gl_periods glp,
2229: gl_sets_of_books glsob,
2230: pa_implementations pai
2231: where pai.set_of_books_id = glsob.set_of_books_id
2232: and glsob.period_set_name = glp.period_set_name

Line 2240: from gl_periods glp,

2236: ELSIF (p_period_type = 'QR') THEN
2237:
2238: select max(glp.end_date)
2239: into l_date
2240: from gl_periods glp,
2241: gl_sets_of_books glsob,
2242: pa_implementations pai
2243: where pai.set_of_books_id = glsob.set_of_books_id
2244: and glsob.period_set_name = glp.period_set_name

Line 2347: from gl_periods glp,

2343:
2344: IF (p_period_type = 'GL') THEN
2345:
2346: select glp.start_date into l_date
2347: from gl_periods glp,
2348: gl_sets_of_books glsob,
2349: pa_implementations pai
2350: where pai.set_of_books_id = glsob.set_of_books_id
2351: and glsob.period_set_name = glp.period_set_name

Line 2385: from gl_periods glp,

2381: ELSIF (p_period_type = 'YR') THEN
2382:
2383: select min(glp.start_date)
2384: into l_date
2385: from gl_periods glp,
2386: gl_sets_of_books glsob,
2387: pa_implementations pai
2388: where pai.set_of_books_id = glsob.set_of_books_id
2389: and glsob.period_set_name = glp.period_set_name

Line 2397: from gl_periods glp,

2393: ELSIF (p_period_type = 'QR') THEN
2394:
2395: select min(glp.start_date)
2396: into l_date
2397: from gl_periods glp,
2398: gl_sets_of_books glsob,
2399: pa_implementations pai
2400: where pai.set_of_books_id = glsob.set_of_books_id
2401: and glsob.period_set_name = glp.period_set_name