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 4588: GL_PERIOD_STATUSES g

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

Line 4624: GL_PERIOD_STATUSES g

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

Line 5546: FROM gl_period_statuses g

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

Line 5758: FROM gl_period_statuses g1

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

Line 5764: FROM gl_period_statuses g2

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

Line 5780: FROM gl_period_statuses g1

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

Line 5786: FROM gl_period_statuses g2

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

Line 10253: , gl_period_statuses gl

10249:
10250: CURSOR future_gl_periods_cur IS
10251: SELECT gl.period_name
10252: FROM pa_implementations i
10253: , gl_period_statuses gl
10254: WHERE gl.application_id = PA_Period_Process_PKG.Application_ID
10255: AND gl.set_of_books_id = i.set_of_books_id
10256: AND gl.adjustment_period_flag = 'N'
10257: AND closing_status = 'F'