APPS.PER_OSE_DEL dependencies on DUAL

Line 33: from sys.dual

29: p_exists_in_hierarchy := 'N';
30:
31: select 'Y'
32: into p_exists_in_hierarchy
33: from sys.dual
34: where exists ( select null
35: from per_org_structure_elements ose
36: where ose.org_structure_version_id = p_org_structure_version_id
37: and ose.organization_id_child = p_organization_id);

Line 45: from sys.dual

41: -- conditionally perform check to see if org is not duplicate of the top org
42: --
43: select 'Y'
44: into p_exists_in_hierarchy
45: from sys.dual
46: where exists ( select null
47: from per_org_structure_elements es1
48: where es1.org_structure_version_id = p_org_structure_version_id
49: and es1.organization_id_parent = p_organization_id