DBA Data[Home] [Help]

APPS.PER_PSE_BUS dependencies on DUAL

Line 272: from sys.dual

268: -- positions in the hierarchy.
269: --
270: select null
271: into l_temp
272: from sys.dual
273: where exists(select 1
274: from per_pos_structure_elements pse
275: where pse.parent_position_id = p_Subordinate_position_Id
276: and pse.pos_structure_version_id = p_Pos_Structure_version_Id);

Line 296: from sys.dual

292: l_dummy VARCHAR2(1);
293: begin
294: select null
295: into l_dummy
296: from sys.dual
297: where exists(select 1
298: from per_security_profiles psp
299: where psp.business_group_id + 0 = p_Business_Group_Id
300: and psp.position_id = p_Subordinate_position_Id