APPS.PA_FIN_PLAN_UTILS dependencies on PA_IMPLEMENTATIONS

Line 4589: FROM PA_IMPLEMENTATIONS i,

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

Line 4625: FROM PA_IMPLEMENTATIONS i,

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

Line 5549: ,pa_implementations i

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

Line 5761: ,pa_implementations i

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

Line 5767: ,pa_implementations i2

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

Line 5783: ,pa_implementations i

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

Line 5789: ,pa_implementations i2

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

Line 7349: ,pa_implementations_all i

7345: ,x_projfunc_cost_rate_type
7346: ,x_project_bil_rate_type
7347: ,x_projfunc_bil_rate_type
7348: FROM pa_projects_all p
7349: ,pa_implementations_all i
7350: WHERE p.project_id = p_project_id
7351: --AND NVL(p.org_id,-99) = NVL(i.org_id,-99);
7352: AND p.org_id = i.org_id; /* Bug 3174677: Added the NVL ,Refer to Update
7353: "16-JAN-04 sagarwal" in the history above.

Line 10258: FROM pa_implementations i

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