APPS.PA_PERF_EXCP_UTILS dependencies on PA_LOOKUPS

Line 30: pa_lookups pl

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
34: AND ppks.current_flag = 'Y'

Line 46: pa_lookups pl

42: get_overall_indicator
43: IS
44: SELECT meaning, attribute1
45: FROM pa_perf_kpa_summary ppks,
46: pa_lookups pl
47: WHERE
48: ppks.object_type = p_object_type
49: AND ppks.object_id = p_object_id
50: AND ppks.current_flag = 'Y'

Line 160: FROM pa_lookups pl

156:
157: CURSOR get_kpa_name (l_kpa_code IN VARCHAR2)
158: IS
159: SELECT meaning
160: FROM pa_lookups pl
161: WHERE pl.lookup_code = l_kpa_code
162: AND pl.lookup_type = 'PA_PERF_KEY_AREAS'
163: AND pl.enabled_flag = 'Y' ;
164:

Line 166: SELECT COUNT(*) FROM pa_lookups

162: AND pl.lookup_type = 'PA_PERF_KEY_AREAS'
163: AND pl.enabled_flag = 'Y' ;
164:
165: CURSOR get_kpa_count IS
166: SELECT COUNT(*) FROM pa_lookups
167: WHERE lookup_type = 'PA_PERF_KEY_AREAS'
168: AND lookup_code <> 'ALL';
169:
170: l_count NUMBER;

Line 222: pa_lookups pl

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
226: AND ppks.current_flag = 'Y'

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')