168: -- If Organization id is null then
169: -- retrieve it.(Only when called from structure_element )
170: Begin
171: --
172: -- Changes 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date tracked positions req.
173: --
174: select p.organization_id
175: into X_Organization_Id
176: from hr_all_positions p
172: -- Changes 01-Oct-99 SCNair (per_all_positions to hr_all_positions) date tracked positions req.
173: --
174: select p.organization_id
175: into X_Organization_Id
176: from hr_all_positions p
177: where p.position_id = X_Position_Id
178: and p.business_group_id + 0 = X_Business_Group_Id;
179: --
180: exception