APPS.PER_ORG_STRUCTURES_PKG dependencies on DUAL

Line 23: from sys.dual

19: -- Get status of Any of HR's Product set.
20: --
21: select 'I'
22: into l_hr_installed
23: from sys.dual
24: where exists (select 'I'
25: from fnd_product_installations
26: where application_id between 800 and 899
27: and status = 'I');

Line 71: from sys.dual

67: l_exists VARCHAR2(1);
68: begin
69: select 'Y'
70: into l_exists
71: from sys.dual
72: where exists(
73: select 'Name exists'
74: from per_organization_structures os
75: where ( os.business_group_id + 0 = p_business_group_id

Line 100: from sys.dual

96: --
97: begin
98: select 'Y'
99: into l_exists
100: from sys.dual
101: where exists(
102: select 'Primary exists'
103: from per_organization_structures os
104: where ( os.business_group_id + 0 = p_business_group_id

Line 138: select 1 from dual

134: and business_group_id = p_business_group_id;
135:
136:
137: cursor C2 is
138: select 1 from dual
139: where exists (
140: select 1
141: from per_org_structure_elements ose,
142: per_org_structure_versions osv

Line 155: l_residual number;

151:
152: Recinfo C3%ROWTYPE;
153:
154: l_duplicate varchar2(10);
155: l_residual number;
156:
157: begin
158: --
159: open c3;

Line 182: fetch c2 into l_residual;

178: elsif ((p_pos_control_structure_flag = 'N') and
179: (Recinfo.position_control_structure_flg = 'Y')) then
180: --
181: open c2;
182: fetch c2 into l_residual;
183:
184: if c2%found then
185: --
186: close c2;

Line 212: from sys.dual

208: -- Is there an osv row below the current Hierarchy.
209: --
210: select 1
211: into l_temp
212: from sys.dual
213: where exists( select 1
214: from per_org_structure_versions osv
215: where ( osv.business_group_id + 0 = p_business_group_id
216: or ( osv.business_group_id is null

Line 267: CURSOR C2 IS SELECT PER_ORGANIZATION_STRUCTURES_S.nextval FROM sys.dual;

263: ) IS
264: --
265: CURSOR C IS SELECT rowid FROM PER_ORGANIZATION_STRUCTURES
266: WHERE organization_structure_id = X_Organization_Structure_Id;
267: CURSOR C2 IS SELECT PER_ORGANIZATION_STRUCTURES_S.nextval FROM sys.dual;
268: --
269: BEGIN
270: --
271: if (X_Organization_Structure_Id is NULL) then

Line 628: from sys.dual

624: -- the affected org_structure_version has actually been edited/queried back.
625: --
626: select null
627: into l_dummy
628: from sys.dual
629: where exists( select 1
630: from per_security_profiles sp
631: where sp.organization_id is not null
632: and ( sp.business_group_id + 0 = p_business_group_id