APPS.PA_PERF_EXCP_UTILS dependencies on PA_PERF_TRANSACTIONS

Line 294: FROM pa_perf_transactions ppt, pa_lookups pl

290: CURSOR get_indicator
291: IS
292: SELECT
293: meaning, attribute1, ppt.perf_txn_id, ppt.exception_flag
294: FROM pa_perf_transactions ppt, pa_lookups pl
295: WHERE
296: ppt.perf_txn_obj_type = p_object_type
297: AND ppt.perf_txn_obj_id = p_object_id
298: AND ppt.period_type = Nvl(p_period_type, ppt.period_type)

Line 396: FROM pa_perf_transactions ppt, pa_lookups pl

392: CURSOR get_indicator (l_measure_id IN NUMBER)
393: IS
394: SELECT
395: meaning, attribute1, ppt.perf_txn_id, ppt.exception_flag
396: FROM pa_perf_transactions ppt, pa_lookups pl
397: WHERE
398: ppt.perf_txn_obj_type = p_object_type
399: AND ppt.perf_txn_obj_id = p_object_id
400: AND ppt.period_TYPE = Nvl(p_period_type, ppt.period_type)

Line 467: FROM pa_perf_transactions ppt, pa_lookups pl

463:
464: -- Executing the bulk fetch query to get the indicators icon
465: SELECT meaning, attribute1, ppt.perf_txn_id, ppt.exception_flag,ppt.measure_id
466: BULK COLLECT INTO l_meaning_tbl, l_icon_tbl, l_perf_txn_id_tbl, l_flag_tbl,l_meaure_id_tbl
467: FROM pa_perf_transactions ppt, pa_lookups pl
468: WHERE ppt.perf_txn_obj_type = p_object_type
469: AND ppt.perf_txn_obj_id = p_object_id
470: AND ppt.period_TYPE = Nvl(p_period_type, ppt.period_type)
471: AND nvl(ppt.period_name, '-9999')

Line 660: where perf_txn_id in (select perf_txn_id from pa_perf_transactions

656: and object_id = p_object_id;
657:
658:
659: delete pa_perf_kpa_trans
660: where perf_txn_id in (select perf_txn_id from pa_perf_transactions
661: where project_id = p_object_id)
662: and kpa_summary_det_id in (select kpa_summary_det_id from pa_perf_kpa_summary_det
663: where object_type = p_object_type
664: and object_id = p_object_id);

Line 675: where perf_txn_id in (select perf_txn_id from pa_perf_transactions

671: where object_type = p_object_type
672: and object_id = p_object_id;
673:
674: delete pa_perf_comments
675: where perf_txn_id in (select perf_txn_id from pa_perf_transactions
676: where project_id = p_object_id);
677:
678: delete pa_perf_transactions
679: where project_id = p_object_id;

Line 678: delete pa_perf_transactions

674: delete pa_perf_comments
675: where perf_txn_id in (select perf_txn_id from pa_perf_transactions
676: where project_id = p_object_id);
677:
678: delete pa_perf_transactions
679: where project_id = p_object_id;
680:
681: PA_DEBUG.Reset_Err_Stack;
682: