APPS.PA_PERF_STATUS_CLIENT_EXTN dependencies on PA_LOOKUPS

Line 25: SELECT To_number(predefined_flag) FROM pa_lookups

21: --- the severity level is from 1 to 5, 1 being the most severe
22:
23: CURSOR get_severity(indicator_code IN VARCHAR2)
24: IS
25: SELECT To_number(predefined_flag) FROM pa_lookups
26: WHERE lookup_type = 'PA_PERF_INDICATORS'
27: AND lookup_code = indicator_code;
28:
29: l_lowest_severity NUMBER := 100;