DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_LOOKUPS

Line 5724: FROM pa_lookups

5720: END IF;
5721:
5722: IF p_project_type = 'CONTRACT' THEN
5723: SELECT ATTRIBUTE12 into l_return_value
5724: FROM pa_lookups
5725: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
5726: ELSIF p_project_type = 'INDIRECT' THEN
5727: SELECT ATTRIBUTE13 into l_return_value
5728: FROM pa_lookups

Line 5728: FROM pa_lookups

5724: FROM pa_lookups
5725: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
5726: ELSIF p_project_type = 'INDIRECT' THEN
5727: SELECT ATTRIBUTE13 into l_return_value
5728: FROM pa_lookups
5729: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
5730: ELSIF p_project_type = 'CAPITAL' THEN
5731: SELECT ATTRIBUTE14 into l_return_value
5732: FROM pa_lookups

Line 5732: FROM pa_lookups

5728: FROM pa_lookups
5729: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
5730: ELSIF p_project_type = 'CAPITAL' THEN
5731: SELECT ATTRIBUTE14 into l_return_value
5732: FROM pa_lookups
5733: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
5734: END IF;
5735:
5736: IF g_debug_mode = 'Y' THEN