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 2074: gl_sets_of_books glsob,

2070: IF (p_period_type = 'GL') THEN
2071:
2072: select glp.end_date into l_date
2073: from gl_periods glp,
2074: gl_sets_of_books glsob,
2075: pa_implementations pai
2076: where pai.set_of_books_id = glsob.set_of_books_id
2077: and glsob.period_set_name = glp.period_set_name
2078: and glsob.accounted_period_type = glp.period_type

Line 2112: gl_sets_of_books glsob,

2108:
2109: select max(glp.end_date)
2110: into l_date
2111: from gl_periods glp,
2112: gl_sets_of_books glsob,
2113: pa_implementations pai
2114: where pai.set_of_books_id = glsob.set_of_books_id
2115: and glsob.period_set_name = glp.period_set_name
2116: and glsob.accounted_period_type = glp.period_type

Line 2124: gl_sets_of_books glsob,

2120:
2121: select max(glp.end_date)
2122: into l_date
2123: from gl_periods glp,
2124: gl_sets_of_books glsob,
2125: pa_implementations pai
2126: where pai.set_of_books_id = glsob.set_of_books_id
2127: and glsob.period_set_name = glp.period_set_name
2128: and glsob.accounted_period_type = glp.period_type

Line 2231: gl_sets_of_books glsob,

2227: IF (p_period_type = 'GL') THEN
2228:
2229: select glp.start_date into l_date
2230: from gl_periods glp,
2231: gl_sets_of_books glsob,
2232: pa_implementations pai
2233: where pai.set_of_books_id = glsob.set_of_books_id
2234: and glsob.period_set_name = glp.period_set_name
2235: and glsob.accounted_period_type = glp.period_type

Line 2269: gl_sets_of_books glsob,

2265:
2266: select min(glp.start_date)
2267: into l_date
2268: from gl_periods glp,
2269: gl_sets_of_books glsob,
2270: pa_implementations pai
2271: where pai.set_of_books_id = glsob.set_of_books_id
2272: and glsob.period_set_name = glp.period_set_name
2273: and glsob.accounted_period_type = glp.period_type

Line 2281: gl_sets_of_books glsob,

2277:
2278: select min(glp.start_date)
2279: into l_date
2280: from gl_periods glp,
2281: gl_sets_of_books glsob,
2282: pa_implementations pai
2283: where pai.set_of_books_id = glsob.set_of_books_id
2284: and glsob.period_set_name = glp.period_set_name
2285: and glsob.accounted_period_type = glp.period_type