DBA Data[Home] [Help]

APPS.PER_DB_PER_SETUP dependencies on HR_ORGANIZATION_UNITS

Line 122: SELECT hr_organization_units_s.nextval

118: end if;
119: --
120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);
121: --
122: SELECT hr_organization_units_s.nextval
123: INTO l_organization_id
124: FROM sys.dual ;
125: --
126: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);

Line 258: FROM hr_organization_units

254: --
255: hr_utility.set_location('per_db_per_setup.insert_org_information',5);
256: SELECT organization_id
257: INTO l_organization_id
258: FROM hr_organization_units
259: WHERE organization_id = p_organization_id;
260: --
261: hr_utility.set_location('per_db_per_setup.insert_org_information',8);
262: if p_org_information_context = 'CLASS' then

Line 378: FROM hr_organization_units hou

374: ,hou.last_updated_by
375: ,hou.last_update_login
376: ,hou.created_by
377: ,hou.creation_date
378: FROM hr_organization_units hou
379: WHERE hou.organization_id = p_organization_id;
380: --
381: return l_org_information_id;
382: --