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.PA_RESOURCE_UTILS dependencies on GL_SETS_OF_BOOKS

Line 2191: gl_sets_of_books glsob,

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
2195: and glsob.accounted_period_type = glp.period_type

Line 2229: gl_sets_of_books glsob,

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
2233: and glsob.accounted_period_type = glp.period_type

Line 2241: gl_sets_of_books glsob,

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
2245: and glsob.accounted_period_type = glp.period_type

Line 2348: gl_sets_of_books glsob,

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
2352: and glsob.accounted_period_type = glp.period_type

Line 2386: gl_sets_of_books glsob,

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
2390: and glsob.accounted_period_type = glp.period_type

Line 2398: gl_sets_of_books glsob,

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
2402: and glsob.accounted_period_type = glp.period_type