DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_QUICK_ENTRY_SPECS_SS_V

Line 2698: FROM PA_QUICK_ENTRY_SPECS_SS_V

2694: THEN
2695: BEGIN
2696: SELECT 'x'
2697: INTO l_dummy_char
2698: FROM PA_QUICK_ENTRY_SPECS_SS_V
2699: WHERE FIELD_NAME = p_field_name
2700: AND LIMITING_VALUE = p_limiting_value;
2701: EXCEPTION
2702: WHEN NO_DATA_FOUND THEN

Line 2730: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed

2726: IF l_project_type_id IS NOT NULL
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

Line 2735: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

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
2736: -- WHERE FIELD_NAME = p_field_name
2737: -- AND object_type_id = l_project_type_id
2738: -- AND LIMITING_VALUE = p_limiting_value;
2739:

Line 2994: FROM PA_QUICK_ENTRY_SPECS_SS_V

2990: THEN
2991: BEGIN
2992: SELECT 'x'
2993: INTO l_dummy_char
2994: FROM PA_QUICK_ENTRY_SPECS_SS_V
2995: WHERE FIELD_NAME = p_field_name
2996: AND LIMITING_VALUE = p_limiting_value;
2997: EXCEPTION
2998: WHEN NO_DATA_FOUND THEN

Line 3027: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed

3023: THEN
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

Line 3032: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

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
3033: -- WHERE FIELD_NAME = p_field_name
3034: -- AND object_type_id = l_project_type_id
3035: -- AND LIMITING_VALUE = p_limiting_value;
3036: