APPS.PA_FIN_PLAN_UTILS dependencies on PA_IMPLEMENTATIONS

Line 4587: FROM PA_IMPLEMENTATIONS i,

4583: ELSIF p_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN
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'

Line 4623: FROM PA_IMPLEMENTATIONS i,

4619: ELSIF p_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN
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'

Line 5547: ,pa_implementations i

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

Line 5759: ,pa_implementations i

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

Line 5765: ,pa_implementations i2

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
5769: AND g2.start_date < g1.start_date

Line 5781: ,pa_implementations i

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

Line 5787: ,pa_implementations i2

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
5791: AND g2.start_date > g1.start_date

Line 7343: ,pa_implementations_all i

7339: ,x_projfunc_cost_rate_type
7340: ,x_project_bil_rate_type
7341: ,x_projfunc_bil_rate_type
7342: FROM pa_projects_all p
7343: ,pa_implementations_all i
7344: WHERE p.project_id = p_project_id
7345: --AND NVL(p.org_id,-99) = NVL(i.org_id,-99);
7346: AND p.org_id = i.org_id; /* Bug 3174677: Added the NVL ,Refer to Update
7347: "16-JAN-04 sagarwal" in the history above.

Line 10252: FROM pa_implementations i

10248: --End of variables used for debugging
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'