APPS.PA_ACCUM_API dependencies on PA_PERIOD_PROCESS_PKG

Line 50: AND sp.application_id = pa_period_process_pkg.application_id

46: FROM gl_period_statuses sp, pa_implementations imp
47: WHERE
48: sp.period_name =x_from_period_name
49: AND sp.set_of_books_id = imp.set_of_books_id
50: AND sp.application_id = pa_period_process_pkg.application_id
51: AND sp.adjustment_period_flag = 'N';
52:
53: if x_start_date is null then
54:

Line 59: AND sp.application_id = pa_period_process_pkg.application_id

55: SELECT MIN(sp.start_date)
56: INTO x_start_date
57: FROM gl_period_statuses sp, pa_implementations imp
58: WHERE sp.set_of_books_id = imp.set_of_books_id
59: AND sp.application_id = pa_period_process_pkg.application_id
60: AND sp.adjustment_period_flag = 'N';
61:
62: end if;
63:

Line 71: AND ep.application_id = pa_period_process_pkg.application_id

67: FROM gl_period_statuses ep, pa_implementations imp
68: WHERE
69: ep.period_name = x_to_period_name
70: AND ep.set_of_books_id = imp.set_of_books_id
71: AND ep.application_id = pa_period_process_pkg.application_id
72: AND ep.adjustment_period_flag = 'N';
73:
74: if x_end_date is null then
75:

Line 80: AND ep.application_id = pa_period_process_pkg.application_id

76: SELECT MAX(ep.end_date)
77: INTO x_end_date
78: FROM gl_period_statuses ep, pa_implementations imp
79: WHERE ep.set_of_books_id = imp.set_of_books_id
80: AND ep.application_id = pa_period_process_pkg.application_id
81: AND ep.adjustment_period_flag = 'N';
82:
83: end if;
84:

Line 266: AND glp.application_id = pa_period_process_pkg.application_id

262: AND nvl(pp.org_id, -1) = nvl(imp.org_id, -1) Commented for bug 2922974 Added for bug 1631100 performance tuning
263: -- Commented for bug 4390421
264: AND glp.period_name = pta.gl_period
265: AND glp.set_of_books_id = imp.set_of_books_id
266: AND glp.application_id = pa_period_process_pkg.application_id
267: AND glp.adjustment_period_flag = 'N'
268: AND glp.start_date BETWEEN
269: x_prd_start_date AND Bug 1631100 removed nvl
270: x_prd_end_date;

Line 574: AND glp.application_id = pa_period_process_pkg.application_id

570: AND x_period_type = 'G'
571: AND pta.gl_period = x_from_period_name;
572: /* Commented for bug 4390421
573: AND glp.set_of_books_id = imp.set_of_books_id
574: AND glp.application_id = pa_period_process_pkg.application_id
575: AND glp.adjustment_period_flag = 'N'
576: AND glp.start_date BETWEEN
577: x_prd_start_date AND
578: x_prd_end_date; */

Line 895: AND glp.application_id = pa_period_process_pkg.application_id

891: )
892: AND x_period_type = 'G'
893: AND glp.period_name = bpv.gl_period_name
894: AND glp.set_of_books_id = imp.set_of_books_id
895: AND glp.application_id = pa_period_process_pkg.application_id
896: AND glp.adjustment_period_flag = 'N'
897: AND glp.start_date BETWEEN
898: NVL(x_start_date,glp.start_date) AND NVL(x_end_date,glp.end_date)
899: AND bpv.budget_type_code = NVL(x_budget_type_code,bpv.budget_type_code) ;

Line 1003: AND glp.application_id = pa_period_process_pkg.application_id

999: )
1000: AND x_period_type = 'G'
1001: AND glp.period_name = bpv.gl_period_name
1002: AND glp.set_of_books_id = imp.set_of_books_id
1003: AND glp.application_id = pa_period_process_pkg.application_id
1004: AND glp.adjustment_period_flag = 'N'
1005: AND glp.start_date BETWEEN
1006: NVL(x_start_date,glp.start_date) AND NVL(x_end_date,glp.end_date)
1007: AND bpv.budget_type_code = NVL(x_budget_type_code,bpv.budget_type_code) ;