APPS.HR_ORGANIZATION_INTERNAL dependencies on HR_ORGANIZATION_INFORMATION

Line 48: hr_organization_information hou1

44: select hou1.org_information_id,hou1.org_information_context,hou1.object_version_number
45: ,ho1.object_version_number
46: from
47: hr_all_organization_units ho1,
48: hr_organization_information hou1
49: where ho1.organization_id=l_organization_id
50: and hou1.organization_id=ho1.organization_id
51: and hou1.org_information_context='Exp Organization Defaults';
52:

Line 151: --Update row in HR_ORGANIZATION_INFORMATION Table

147:
148: --check if hr organization exists
149: if (l_organization_id is not null) then
150:
151: --Update row in HR_ORGANIZATION_INFORMATION Table
152:
153: open get_internal_external_flag;
154: fetch get_internal_external_flag into l_int_ext_check;
155: if (get_internal_external_flag%notfound) then