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_ACCUM_API dependencies on PA_PERIODS

Line 87: -- Get the dates from PA_PERIODS table

83: end if;
84:
85: ELSE
86:
87: -- Get the dates from PA_PERIODS table
88:
89: SELECT MIN(sp.start_date)
90: INTO x_start_date
91: FROM pa_periods sp

Line 91: FROM pa_periods sp

87: -- Get the dates from PA_PERIODS table
88:
89: SELECT MIN(sp.start_date)
90: INTO x_start_date
91: FROM pa_periods sp
92: WHERE sp.period_name = x_from_period_name;
93:
94: IF ( x_start_date IS NULL ) THEN
95: SELECT MIN(sp.start_date)

Line 97: FROM pa_periods sp;

93:
94: IF ( x_start_date IS NULL ) THEN
95: SELECT MIN(sp.start_date)
96: INTO x_start_date
97: FROM pa_periods sp;
98: END IF;
99:
100: SELECT MAX(ep.end_date)
101: INTO x_end_date

Line 102: FROM pa_periods ep

98: END IF;
99:
100: SELECT MAX(ep.end_date)
101: INTO x_end_date
102: FROM pa_periods ep
103: WHERE ep.period_name = x_to_period_name;
104:
105: IF (x_end_date IS NULL ) THEN
106: SELECT MAX(ep.end_date)

Line 108: FROM pa_periods ep;

104:
105: IF (x_end_date IS NULL ) THEN
106: SELECT MAX(ep.end_date)
107: INTO x_end_date
108: FROM pa_periods ep;
109: END IF;
110:
111: /*
112: SELECT MIN(sp.start_date)

Line 114: FROM pa_periods sp

110:
111: /*
112: SELECT MIN(sp.start_date)
113: INTO x_start_date
114: FROM pa_periods sp
115: WHERE
116: sp.period_name = NVL(x_from_period_name,sp.period_name);
117:
118: SELECT MAX(ep.end_date)

Line 120: FROM pa_periods ep

116: sp.period_name = NVL(x_from_period_name,sp.period_name);
117:
118: SELECT MAX(ep.end_date)
119: INTO x_end_date
120: FROM pa_periods ep
121: WHERE
122: ep.period_name = NVL(x_to_period_name,ep.period_name);
123: */
124:

Line 158: 1. Replaced pa_periods with pa_periods_all with join with pa_implementations.

154: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155: x_err_code IN OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
156: IS
157: /* Done changes for bug 1631100.
158: 1. Replaced pa_periods with pa_periods_all with join with pa_implementations.
159: 2. Removed nvl for start and end date so that index can be used
160: */
161:
162: -- Modified for bug 4390421

Line 180: pa_periods_all pp,

176: tot_cmt_burdened_cost,
177: unit_of_measure
178: FROM
179: pa_txn_accum pta /*, commented for bug 4390421
180: pa_periods_all pp,
181: pa_implementations imp */
182: WHERE
183: x_period_type = 'P'
184: AND pta.project_id = x_project_id

Line 211: /* Made changes for bug 1631100. For performance improvement added pa_periods table so that

207: AND pp.start_date BETWEEN
208: x_prd_start_date AND -- Bug 1631100 Removed nvl
209: x_prd_end_date;
210: */
211: /* Made changes for bug 1631100. For performance improvement added pa_periods table so that
212: index on project_id , pa_period gets effectively used.
213: For consistency purpose removed nvl for start date/end date. Refer bugdb for more details
214: */
215:

Line 236: pa_periods_all pp, Commented for bug 2922974 Added for bug 1631100 performance tuning */

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'
240: AND pta.project_id = x_project_id

Line 412: replaced pa_periods with pa_periods_all. Removed nvl for start date and end date.

408: IS
409: /* Modified for performance. Bug 1631100
410: Moved join for project_id and task_id to the pa_txn_accum table and joining to pa_resource
411: accum_details thru txn_accum_id.
412: replaced pa_periods with pa_periods_all. Removed nvl for start date and end date.
413: Now index on project_id and pa_period will be very effectively used on pa_txn_accum
414: */
415:
416: -- Commented for bug 4390421

Line 434: pa_periods_all pp,

430: PTA.TOT_CMT_BURDENED_COST,
431: PTA.UNIT_OF_MEASURE
432: FROM
433: PA_TXN_ACCUM PTA /*, Commented for bug 4390421
434: pa_periods_all pp,
435: pa_implementations imp */
436: WHERE PTA.PROJECT_ID = X_PROJECT_ID
437: AND (
438: (x_task_id IS NULL) --- project level numbers

Line 495: Added pa_periods_all table to the from clause so that index on project_id, pa_period can

491:
492: /* Modified for performance. Bug 1631100
493: Moved join for project_id and task_id to the pa_txn_accum table and joining to pa_resource
494: accum_details thru txn_accum_id.
495: Added pa_periods_all table to the from clause so that index on project_id, pa_period can
496: be used.
497: removed nvl from start date/end date for consistencey purpose.
498: */
499:

Line 521: /* PA_PERIODS_ALL PP commented for bug 2922974 */

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 (
524: (x_task_id IS NULL) --- project level numbers
525: OR

Line 839: pa_periods pp

835: bpv.orig_quantity,
836: bpv.orig_labor_quantity
837: FROM
838: pa_budget_by_pa_period_v bpv,
839: pa_periods pp
840: WHERE
841: bpv.project_id = x_project_id
842: AND (
843: (x_task_id IS NULL) --- project level numbers

Line 921: pa_periods pp

917: bpv.orig_quantity,
918: bpv.orig_labor_quantity
919: FROM
920: pa_budget_by_pa_period_v bpv,
921: pa_periods pp
922: WHERE
923: bpv.project_id = x_project_id
924: AND (
925: (x_task_id IS NULL) --- project level numbers