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 PA_PERIOD_PROCESS_PKG

Line 4590: AND g.application_id = pa_period_process_pkg.application_id

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;
4593: END IF;
4594: END IF;

Line 4626: AND g.application_id = pa_period_process_pkg.application_id

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;
4629: END IF;
4630: END IF;

Line 5548: WHERE g.application_id = pa_period_process_pkg.application_id

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'
5551: AND g.period_name = p_period_name;
5552:

Line 5760: WHERE g1.application_id = pa_period_process_pkg.application_id

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'
5763: AND p_number_of_periods = (SELECT COUNT(*)
5764: FROM gl_period_statuses g2

Line 5767: AND g2.application_id =pa_period_process_pkg.application_id

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
5769: AND g2.start_date < g1.start_date
5770: AND g2.start_date >= l_start_date);
5771:

Line 5782: WHERE g1.application_id = pa_period_process_pkg.application_id

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'
5785: AND abs(p_number_of_periods) = (SELECT COUNT(*)
5786: FROM gl_period_statuses g2

Line 5789: AND g2.application_id = pa_period_process_pkg.application_id

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
5791: AND g2.start_date > g1.start_date
5792: AND g2.start_date <= l_start_date);
5793: ELSIF p_number_of_periods = 0 THEN

Line 10254: WHERE gl.application_id = PA_Period_Process_PKG.Application_ID

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'
10258: ORDER BY gl.start_date;