APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_VALID_CATEGORIES_V

Line 2731: -- PA_VALID_CATEGORIES_V directly fr performance .

2727: THEN
2728: -- Bug#3693202
2729: -- Commented the existing select which looks into
2730: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed
2731: -- PA_VALID_CATEGORIES_V directly fr performance .
2732:
2733: -- SELECT 'x'
2734: -- INTO l_dummy_char
2735: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

Line 2743: FROM pa_valid_categories_v pvc ,

2739:
2740:
2741: SELECT 'X'
2742: INTO l_dummy_char
2743: FROM pa_valid_categories_v pvc ,
2744: pa_lookups pl
2745: WHERE pvc.object_type = 'PA_PROJECTS'
2746: AND pvc.object_type_id = l_project_type_id
2747: AND 'CLASSIFICATION' = pl.lookup_code

Line 3028: -- PA_VALID_CATEGORIES_V directly fr performance .

3024:
3025: -- Bug#3693202
3026: -- Commented the existing select which looks into
3027: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed
3028: -- PA_VALID_CATEGORIES_V directly fr performance .
3029:
3030: -- SELECT 'x'
3031: -- INTO l_dummy_char
3032: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

Line 3039: FROM pa_valid_categories_v pvc ,

3035: -- AND LIMITING_VALUE = p_limiting_value;
3036:
3037: SELECT 'X'
3038: INTO l_dummy_char
3039: FROM pa_valid_categories_v pvc ,
3040: pa_lookups pl
3041: WHERE pvc.object_type = 'PA_PROJECTS'
3042: AND pvc.object_type_id = l_project_type_id
3043: AND 'CLASSIFICATION' = pl.lookup_code