50: select
51: ver.org_structure_version_id
52: from
53: per_organization_structures str
54: , per_org_structure_versions ver
55: where
56: str.position_control_structure_flg = 'Y'
57: and str.business_group_id = p_business_group_id
58: and ver.business_group_id = p_business_group_id
1363: --
1364: cursor c_org_version(p_effective_date date) is
1365: select ver.org_structure_version_id
1366: from per_organization_structures str
1367: , per_org_structure_versions ver
1368: where str.position_control_structure_flg = 'Y'
1369: and str.organization_structure_id = p_org_structure_id
1370: and str.business_group_id = p_business_group_id
1371: and ver.business_group_id = p_business_group_id
3273: --
3274: cursor c_org_version(p_effective_date date) is
3275: select ver.org_structure_version_id
3276: from per_organization_structures str
3277: , per_org_structure_versions ver
3278: where str.position_control_structure_flg = 'Y'
3279: and str.organization_structure_id = p_org_structure_id
3280: and str.business_group_id = p_business_group_id
3281: and ver.business_group_id = p_business_group_id