APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_VALID_CATEGORIES_V

Line 2726: -- PA_VALID_CATEGORIES_V directly fr performance .

2722: THEN
2723: -- Bug#3693202
2724: -- Commented the existing select which looks into
2725: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed
2726: -- PA_VALID_CATEGORIES_V directly fr performance .
2727:
2728: -- SELECT 'x'
2729: -- INTO l_dummy_char
2730: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

Line 2738: FROM pa_valid_categories_v pvc ,

2734:
2735:
2736: SELECT 'X'
2737: INTO l_dummy_char
2738: FROM pa_valid_categories_v pvc ,
2739: pa_lookups pl
2740: WHERE pvc.object_type = 'PA_PROJECTS'
2741: AND pvc.object_type_id = l_project_type_id
2742: AND 'CLASSIFICATION' = pl.lookup_code

Line 3023: -- PA_VALID_CATEGORIES_V directly fr performance .

3019:
3020: -- Bug#3693202
3021: -- Commented the existing select which looks into
3022: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed
3023: -- PA_VALID_CATEGORIES_V directly fr performance .
3024:
3025: -- SELECT 'x'
3026: -- INTO l_dummy_char
3027: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

Line 3034: FROM pa_valid_categories_v pvc ,

3030: -- AND LIMITING_VALUE = p_limiting_value;
3031:
3032: SELECT 'X'
3033: INTO l_dummy_char
3034: FROM pa_valid_categories_v pvc ,
3035: pa_lookups pl
3036: WHERE pvc.object_type = 'PA_PROJECTS'
3037: AND pvc.object_type_id = l_project_type_id
3038: AND 'CLASSIFICATION' = pl.lookup_code