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_FIN_PLAN_UTILS dependencies on GL_PERIOD_STATUSES

Line 4590: GL_PERIOD_STATUSES g

4586: IF p_input_date IS NOT NULL THEN
4587: SELECT g.start_date
4588: INTO l_start_date
4589: FROM PA_IMPLEMENTATIONS i,
4590: GL_PERIOD_STATUSES g
4591: WHERE g.set_of_books_id = i.set_of_books_id
4592: AND g.application_id = pa_period_process_pkg.application_id
4593: AND g.adjustment_period_flag = 'N'
4594: AND p_input_date between g.start_date and g.end_date;

Line 4626: GL_PERIOD_STATUSES g

4622: IF p_input_date IS NOT NULL THEN
4623: SELECT g.end_date
4624: INTO l_end_date
4625: FROM PA_IMPLEMENTATIONS i,
4626: GL_PERIOD_STATUSES g
4627: WHERE g.set_of_books_id = i.set_of_books_id
4628: AND g.application_id = pa_period_process_pkg.application_id
4629: AND g.adjustment_period_flag = 'N'
4630: AND p_input_date between g.start_date and g.end_date;

Line 5548: FROM gl_period_statuses g

5544: SELECT start_date
5545: ,end_date
5546: INTO x_start_date
5547: ,x_end_date
5548: FROM gl_period_statuses g
5549: ,pa_implementations i
5550: WHERE g.application_id = pa_period_process_pkg.application_id
5551: AND g.set_of_books_id = i.set_of_books_id
5552: AND g.adjustment_period_flag = 'N'

Line 5760: FROM gl_period_statuses g1

5756: ,end_date
5757: INTO x_shifted_period
5758: ,x_shifted_period_start_date
5759: ,x_shifted_period_end_date
5760: FROM gl_period_statuses g1
5761: ,pa_implementations i
5762: WHERE g1.application_id = pa_period_process_pkg.application_id
5763: AND g1.set_of_books_id = i.set_of_books_id
5764: AND g1.adjustment_period_flag = 'N'

Line 5766: FROM gl_period_statuses g2

5762: WHERE g1.application_id = pa_period_process_pkg.application_id
5763: AND g1.set_of_books_id = i.set_of_books_id
5764: AND g1.adjustment_period_flag = 'N'
5765: AND p_number_of_periods = (SELECT COUNT(*)
5766: FROM gl_period_statuses g2
5767: ,pa_implementations i2
5768: WHERE g2.adjustment_period_flag = 'N'
5769: AND g2.application_id =pa_period_process_pkg.application_id
5770: AND g2.set_of_books_id = i2.set_of_books_id

Line 5782: FROM gl_period_statuses g1

5778: ,end_date
5779: INTO x_shifted_period
5780: ,x_shifted_period_start_date
5781: ,x_shifted_period_end_date
5782: FROM gl_period_statuses g1
5783: ,pa_implementations i
5784: WHERE g1.application_id = pa_period_process_pkg.application_id
5785: AND g1.set_of_books_id = i.set_of_books_id
5786: AND g1.adjustment_period_flag = 'N'

Line 5788: FROM gl_period_statuses g2

5784: WHERE g1.application_id = pa_period_process_pkg.application_id
5785: AND g1.set_of_books_id = i.set_of_books_id
5786: AND g1.adjustment_period_flag = 'N'
5787: AND abs(p_number_of_periods) = (SELECT COUNT(*)
5788: FROM gl_period_statuses g2
5789: ,pa_implementations i2
5790: WHERE g2.adjustment_period_flag = 'N'
5791: AND g2.application_id = pa_period_process_pkg.application_id
5792: AND g2.set_of_books_id = i2.set_of_books_id

Line 10259: , gl_period_statuses gl

10255:
10256: CURSOR future_gl_periods_cur IS
10257: SELECT gl.period_name
10258: FROM pa_implementations i
10259: , gl_period_statuses gl
10260: WHERE gl.application_id = PA_Period_Process_PKG.Application_ID
10261: AND gl.set_of_books_id = i.set_of_books_id
10262: AND gl.adjustment_period_flag = 'N'
10263: AND closing_status = 'F'