DBA Data[Home] [Help]

APPS.PER_ORG_STRUCTURES_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 141: from per_org_structure_elements ose,

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
143: where osv.org_structure_version_id = ose.org_structure_version_id(+)
144: and (ose.position_control_enabled_flag = 'Y' or
145: osv.topnode_pos_ctrl_enabled_flag = 'Y'));

Line 646: from per_org_structure_elements ose

642: and osv.org_structure_version_id = p_org_structure_version_id /* 1301741 */
643: and not exists
644: (
645: select null
646: from per_org_structure_elements ose
647: where ose.org_structure_version_id =
648: osv.org_structure_version_id
649: and (sp.organization_id =
650: ose.organization_id_child