APPS.PA_ACCUM_API dependencies on PA_TXN_ACCUM

Line 179: pa_txn_accum pta /*, commented for bug 4390421

175: tot_cmt_raw_cost,
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'

Line 199: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

195: )
196: )
197: )
198: AND EXISTS
199: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
200: WHERE
201: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
202: )
203: AND pta.pa_period = x_from_period_name ;

Line 237: pa_txn_accum pta

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
241: AND (

Line 255: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

251: )
252: )
253: )
254: AND EXISTS
255: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
256: WHERE
257: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
258: )
259: AND pta.gl_period = x_from_period_name ; -- Added for bug 4390421

Line 410: Moved join for project_id and task_id to the pa_txn_accum table and joining to pa_resource

406: x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
407: x_err_code IN OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
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: */

Line 413: Now index on project_id and pa_period will be very effectively used on pa_txn_accum

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
417: -- CURSOR selresaccums_p(x_prd_start_date IN DATE, x_prd_end_date IN DATE) IS

Line 433: PA_TXN_ACCUM PTA /*, Commented for bug 4390421

429: PTA.TOT_CMT_RAW_COST,
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 (

Line 478: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

474: SYS.DUAL */
475: )
476: )
477: AND EXISTS
478: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
479: WHERE
480: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
481: )
482: AND x_period_type = 'P'

Line 493: Moved join for project_id and task_id to the pa_txn_accum table and joining to pa_resource

489: x_prd_end_date;
490: */
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.

Line 520: PA_TXN_ACCUM PTA

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

Line 563: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD

559: SYS.DUAL */
560: )
561: )
562: AND EXISTS
563: ( SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD
564: WHERE
565: PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID
566: )
567: /* AND pp.gl_period_name = glp.period_name commented for bug 2922974 Added for bug 1631100 performance tuning