DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS2 dependencies on HR_ORGANIZATION_INFORMATION

Line 82: from hr_organization_information org

78: select nvl(decode(pt.project_type_class_code,'INDIRECT',org_information1
79: , 'CAPITAL',org_information12
80: , 'CONTRACT',org_information13),'Y')
81: ,meaning
82: from hr_organization_information org
83: , pa_project_types_all pt -- Bug#3807805 : Modified pa_project_types to pa_project_types_all
84: , pa_lookups lps
85: where org.organization_id(+) = nvl(x_new_value,x_old_value)
86: and upper(org.org_information_context(+)) = upper('Project Type Class Information')