APPS.PER_POSITION_STRUCTURES_PKG dependencies on DUAL

Line 18: from sys.dual

14: l_hr_installed varchar2(1);
15: begin
16: select 'I'
17: into l_hr_installed
18: from sys.dual
19: where exists (select 'I'
20: from fnd_product_installations
21: where application_id between 800 and 899
22: and status = 'I');

Line 77: from sys.dual

73: l_duplicate_name VARCHAR2(20);
74: begin
75: select 'Duplicate exists'
76: into l_duplicate_name
77: from sys.dual
78: where exists (
79: select 1
80: from per_position_structures psp
81: where (psp.rowid <> X_Rowid

Line 106: from sys.dual

102: if X_Primary_flag = 'Y' then
103: begin
104: select 'Primary Exists'
105: into l_primary_exists
106: from sys.dual
107: where exists (
108: select 1
109: from per_position_structures psp
110: where (psp.rowid <> X_Rowid

Line 144: from sys.dual

140: Begin
141: begin
142: select 'Versions Exist'
143: into l_exists
144: from sys.dual
145: where exists(
146: select 1
147: from per_pos_structure_versions psv
148: where psv.position_structure_id = X_Position_Structure_Id);

Line 163: from sys.dual

159: if X_Hr_Installed = 'Y' then
160: begin
161: select 'Security exists'
162: into l_exists
163: from sys.dual
164: where exists (
165: select null
166: from per_security_profiles sec
167: where sec.business_group_id + 0 = X_Business_Group_Id

Line 189: ||'from sys.dual '

185: -- This uses a similar method to OCI but Via PL/SQL instead.
186: --
187: begin
188: l_sql_text := 'select null '
189: ||'from sys.dual '
190: ||'where exists( select null '
191: ||' from po_system_parameters '
192: ||' where security_position_structure_id = '
193: ||to_char(X_Position_Structure_Id)

Line 269: CURSOR C2 IS SELECT per_position_structures_s.nextval FROM sys.dual;

265: ) IS
266: CURSOR C IS SELECT rowid FROM PER_POSITION_STRUCTURES
267:
268: WHERE position_structure_id = X_Position_Structure_Id;
269: CURSOR C2 IS SELECT per_position_structures_s.nextval FROM sys.dual;
270: BEGIN
271: check_name_unique(X_Rowid => X_Rowid,
272: X_Name => X_Name,
273: X_Business_Group_id => X_Business_Group_id);

Line 575: from sys.dual

571: l_dummy VARCHAR2(1);
572: begin
573: select null
574: into l_dummy
575: from sys.dual
576: where exists( select 1
577: from per_security_profiles sp
578: where sp.position_id is not null
579: and sp.business_group_id + 0 = p_business_group_id