APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_LOOKUPS

Line 357: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups

353:
354: /* Get all the project_id with rule_id and store it in PLSQL table */
355: CURSOR get_proj_rule_id (l_proj_id IN NUMBER) IS
356: SELECT distinct(ppor.object_id)
357: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups
358: WHERE ppor.object_id = l_proj_id
359: AND ppor.rule_id is not null
360: AND ppor.object_type = 'PA_PROJECTS'
361: AND ppor.rule_id = ppr.rule_id

Line 370: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups

366:
367: /* Get all the rule_id associated with the project_id */
368: CURSOR get_rule_id (l_proj_id IN NUMBER) IS
369: SELECT ppor.rule_id
370: FROM pa_perf_object_rules ppor, pa_perf_rules ppr, pa_lookups pl -- Bug 4275320: Added pa_lookups
371: WHERE ppor.object_id = l_proj_id
372: AND ppor.object_type = 'PA_PROJECTS'
373: AND ppor.rule_id = ppr.rule_id
374: AND ppr.rule_type = 'PERF_RULE'

Line 579: FROM pa_lookups

575:
576: FOR i IN l_bz_code_list.FIRST .. l_bz_code_list.LAST LOOP
577: SELECT attribute1
578: INTO l_program_name
579: FROM pa_lookups
580: WHERE lookup_type = 'PA_PERF_BZ_EVENTS'
581: AND lookup_code = l_bz_code_list(i)
582: AND enabled_flag = 'Y';
583:

Line 585: -- Construct the dynamic SQL that will call the API from PA_LOOKUPS

581: AND lookup_code = l_bz_code_list(i)
582: AND enabled_flag = 'Y';
583:
584: IF ( l_program_name IS NOT NULL ) THEN
585: -- Construct the dynamic SQL that will call the API from PA_LOOKUPS
586: -- for PA_PERF_BZ_EVENTS lookup_type --
587: -- l_program_name is the name of the extension API.
588: -- For instance 'SUMMARIZATION.EXCEPTION'
589:

Line 1404: FROM pa_lookups

1400: l_count_list PA_PLSQL_DATATYPES.NumTabTyp ;
1401:
1402: CURSOR get_kpas IS
1403: SELECT lookup_code
1404: FROM pa_lookups
1405: WHERE lookup_type = 'PA_PERF_KEY_AREAS'
1406: AND lookup_code <> 'ALL'
1407: ORDER BY To_number(predefined_flag) ASC ;
1408:

Line 1475: FROM pa_lookups

1471:
1472: CURSOR get_indicator
1473: IS
1474: SELECT lookup_code
1475: FROM pa_lookups
1476: WHERE lookup_type = 'PA_PERF_INDICATORS'
1477: ORDER BY predefined_flag ASC;
1478:
1479: l_errbuf VARCHAR2(500);