APPS.PJI_REP_UTIL dependencies on PA_LOOKUPS

Line 6208: FROM pa_lookups

6204: END IF;
6205:
6206: IF p_project_type = 'CONTRACT' THEN
6207: SELECT ATTRIBUTE12 into l_return_value
6208: FROM pa_lookups
6209: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
6210: ELSIF p_project_type = 'INDIRECT' THEN
6211: SELECT ATTRIBUTE13 into l_return_value
6212: FROM pa_lookups

Line 6212: FROM pa_lookups

6208: FROM pa_lookups
6209: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
6210: ELSIF p_project_type = 'INDIRECT' THEN
6211: SELECT ATTRIBUTE13 into l_return_value
6212: FROM pa_lookups
6213: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
6214: ELSIF p_project_type = 'CAPITAL' THEN
6215: SELECT ATTRIBUTE14 into l_return_value
6216: FROM pa_lookups

Line 6216: FROM pa_lookups

6212: FROM pa_lookups
6213: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
6214: ELSIF p_project_type = 'CAPITAL' THEN
6215: SELECT ATTRIBUTE14 into l_return_value
6216: FROM pa_lookups
6217: WHERE lookup_code = p_page_type and lookup_type='PA_PAGE_TYPES';
6218: END IF;
6219:
6220: IF g_debug_mode = 'Y' THEN