APPS.PA_PERF_EXCP_UTILS dependencies on PA_PERF_KPA_SUMMARY_DET

Line 29: FROM pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppksd,

25:
26: CURSOR get_indicator (l_kpa_code IN VARCHAR2)
27: IS
28: SELECT meaning, attribute1
29: FROM pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppksd,
30: pa_lookups pl
31: WHERE
32: ppks.object_type = p_object_type
33: AND ppks.object_id = p_object_id

Line 221: FROM pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppksd,

217:
218: CURSOR get_indicator
219: IS
220: SELECT meaning, attribute1
221: FROM pa_perf_kpa_summary ppks, pa_perf_kpa_summary_det ppksd,
222: pa_lookups pl
223: WHERE
224: ppks.object_type = p_object_type
225: AND ppks.object_id = p_object_id

Line 662: and kpa_summary_det_id in (select kpa_summary_det_id from pa_perf_kpa_summary_det

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);
665:
666: delete pa_perf_kpa_summary_det

Line 666: delete pa_perf_kpa_summary_det

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);
665:
666: delete pa_perf_kpa_summary_det
667: where object_type = p_object_type
668: and object_id = p_object_id;
669:
670: delete pa_perf_kpa_summary