DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_QUICK_ENTRY_SPECS_SS_V

Line 2693: FROM PA_QUICK_ENTRY_SPECS_SS_V

2689: THEN
2690: BEGIN
2691: SELECT 'x'
2692: INTO l_dummy_char
2693: FROM PA_QUICK_ENTRY_SPECS_SS_V
2694: WHERE FIELD_NAME = p_field_name
2695: AND LIMITING_VALUE = p_limiting_value;
2696: EXCEPTION
2697: WHEN NO_DATA_FOUND THEN

Line 2725: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed

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

Line 2730: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

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
2731: -- WHERE FIELD_NAME = p_field_name
2732: -- AND object_type_id = l_project_type_id
2733: -- AND LIMITING_VALUE = p_limiting_value;
2734:

Line 2989: FROM PA_QUICK_ENTRY_SPECS_SS_V

2985: THEN
2986: BEGIN
2987: SELECT 'x'
2988: INTO l_dummy_char
2989: FROM PA_QUICK_ENTRY_SPECS_SS_V
2990: WHERE FIELD_NAME = p_field_name
2991: AND LIMITING_VALUE = p_limiting_value;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN

Line 3022: -- PA_QUICK_ENTRY_SPECS_SS_V view , instead accessed

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

Line 3027: -- FROM PA_QUICK_ENTRY_SPECS_SS_V

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
3028: -- WHERE FIELD_NAME = p_field_name
3029: -- AND object_type_id = l_project_type_id
3030: -- AND LIMITING_VALUE = p_limiting_value;
3031: