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 4592: AND g.application_id = pa_period_process_pkg.application_id

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;
4595: END IF;
4596: END IF;

Line 4628: AND g.application_id = pa_period_process_pkg.application_id

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;
4631: END IF;
4632: END IF;

Line 5550: WHERE g.application_id = pa_period_process_pkg.application_id

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

Line 5762: WHERE g1.application_id = pa_period_process_pkg.application_id

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

Line 5769: AND g2.application_id =pa_period_process_pkg.application_id

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

Line 5784: WHERE g1.application_id = pa_period_process_pkg.application_id

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

Line 5791: AND g2.application_id = pa_period_process_pkg.application_id

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

Line 10260: WHERE gl.application_id = PA_Period_Process_PKG.Application_ID

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