APPS.PA_ACCUM_API dependencies on GL_PERIOD_STATUSES

Line 23: -- Get the dates from GL_PERIOD_STATUSES table

19:
20: -- Get the period start date and end date
21:
22: IF ( x_period_type = 'G' ) THEN
23: -- Get the dates from GL_PERIOD_STATUSES table
24: /*
25: SELECT MIN(sp.start_date)
26: INTO x_start_date
27: FROM gl_period_statuses sp, pa_implementations imp

Line 27: FROM gl_period_statuses sp, pa_implementations imp

23: -- Get the dates from GL_PERIOD_STATUSES table
24: /*
25: SELECT MIN(sp.start_date)
26: INTO x_start_date
27: FROM gl_period_statuses sp, pa_implementations imp
28: WHERE
29: sp.period_name = NVL(x_from_period_name,sp.period_name)
30: AND sp.set_of_books_id = imp.set_of_books_id
31: AND sp.application_id = 101

Line 36: FROM gl_period_statuses ep, pa_implementations imp

32: AND sp.adjustment_period_flag = 'N';
33:
34: SELECT MAX(ep.end_date)
35: INTO x_end_date
36: FROM gl_period_statuses ep, pa_implementations imp
37: WHERE
38: ep.period_name = NVL(x_to_period_name,ep.period_name)
39: AND ep.set_of_books_id = imp.set_of_books_id
40: AND ep.application_id = 101

Line 46: FROM gl_period_statuses sp, pa_implementations imp

42: */
43:
44: SELECT MIN(sp.start_date)
45: INTO x_start_date
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

Line 57: FROM gl_period_statuses sp, pa_implementations imp

53: if x_start_date is null then
54:
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:

Line 67: FROM gl_period_statuses ep, pa_implementations imp

63:
64:
65: SELECT MAX(ep.end_date)
66: INTO x_end_date
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

Line 78: FROM gl_period_statuses ep, pa_implementations imp

74: if x_end_date is null then
75:
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:

Line 235: gl_period_statuses glp,

231: unit_of_measure
232: FROM
233: /* commented for bug 4390421
234: pa_implementations imp,
235: gl_period_statuses glp,
236: pa_periods_all pp, Commented for bug 2922974 Added for bug 1631100 performance tuning */
237: pa_txn_accum pta
238: WHERE
239: x_period_type = 'G'

Line 519: gl_period_statuses glp, */

515: PTA.UNIT_OF_MEASURE
516: FROM
517: /* Commented for bug 4390421
518: pa_implementations imp,
519: gl_period_statuses glp, */
520: PA_TXN_ACCUM PTA
521: /* PA_PERIODS_ALL PP commented for bug 2922974 */
522: WHERE PTA.PROJECT_ID = X_PROJECT_ID
523: AND (

Line 875: gl_period_statuses glp,

871: bpv.orig_quantity,
872: bpv.orig_labor_quantity
873: FROM
874: pa_budget_by_pa_period_v bpv,
875: gl_period_statuses glp,
876: pa_implementations imp
877: WHERE
878: bpv.project_id = x_project_id
879: AND (

Line 970: gl_period_statuses glp,

966: bpv.orig_quantity,
967: bpv.orig_labor_quantity
968: FROM
969: pa_budget_by_pa_period_v bpv,
970: gl_period_statuses glp,
971: pa_implementations imp
972: WHERE
973: bpv.project_id = x_project_id
974: AND (