APPS.PA_RESOURCE_UTILS dependencies on GL_PERIODS

Line 2073: from gl_periods glp,

2069:
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

Line 2111: from gl_periods glp,

2107: ELSIF (p_period_type = 'YR') THEN
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

Line 2123: from gl_periods glp,

2119: ELSIF (p_period_type = 'QR') THEN
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

Line 2230: from gl_periods glp,

2226:
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

Line 2268: from gl_periods glp,

2264: ELSIF (p_period_type = 'YR') THEN
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

Line 2280: from gl_periods glp,

2276: ELSIF (p_period_type = 'QR') THEN
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