DBA Data[Home] [Help]

APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 54: , per_org_structure_versions ver

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

Line 1367: , per_org_structure_versions ver

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

Line 3277: , per_org_structure_versions ver

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