APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 97: from per_org_structure_versions x

93: or ( a.business_group_id is null
94: and p_business_group_id is null))
95: and a.org_structure_version_id in
96: ( select x.org_structure_version_id
97: from per_org_structure_versions x
98: where x.organization_structure_id =
99: p_sec_org_structure_id)
100: connect by prior
101: a.organization_id_child = a.organization_id_parent

Line 104: from per_org_structure_versions x

100: connect by prior
101: a.organization_id_child = a.organization_id_parent
102: and a.org_structure_version_id in
103: ( select x.org_structure_version_id
104: from per_org_structure_versions x
105: where x.organization_structure_id =
106: p_sec_org_structure_id)
107: and ( a.business_group_id + 0 = p_business_group_id
108: or ( a.business_group_id is null

Line 114: from per_org_structure_versions x

110: start with
111: a.organization_id_parent = p_sec_org_id
112: and a.org_structure_version_id in
113: ( select x.org_structure_version_id
114: from per_org_structure_versions x
115: where x.organization_structure_id =
116: p_sec_org_structure_id)
117: and ( a.business_group_id + 0 = p_business_group_id
118: or ( a.business_group_id is null

Line 243: from per_org_structure_versions osv

239: from per_security_profiles psp
240: where psp.include_top_organization_flag = 'Y'
241: and psp.organization_structure_id =
242: (select osv.organization_structure_id
243: from per_org_structure_versions osv
244: where osv.org_structure_version_id =
245: p_org_structure_version_id)
246: and ((psp.organization_id = p_org_id_child)
247: or(psp.organization_id = p_org_id_parent

Line 326: , per_org_structure_versions posv

322: --
323: cursor c2 is
324: select 'Y'
325: from per_security_profiles psp
326: , per_org_structure_versions posv
327: where ( psp.business_group_id =p_business_group_id
328: or ( psp.business_group_id is null
329: and p_business_group_id is null))
330: and psp.organization_id = p_org_id_child

Line 431: per_org_structure_versions osv

427:
428: cursor c1 is
429: select str.position_control_structure_flg
430: from per_organization_structures str,
431: per_org_structure_versions osv
432: where osv.org_structure_version_id = p_org_structure_version_id
433: and osv.organization_structure_id = str.organization_structure_id;
434:
435: l_result varchar2(10);