DBA Data[Home] [Help]

APPS.PER_PQH_SHR dependencies on PER_ORGANIZATION_STRUCTURES

Line 27: per_organization_structures str

23: cursor c2(p_business_group_id number, p_effective_date date) is
24: select ver.org_structure_version_id
25: from
26: per_org_structure_versions ver,
27: per_organization_structures str
28: where
29: ver.organization_structure_id = str.organization_structure_id
30: and str.business_group_id = p_business_group_id
31: and str.position_control_structure_flg='Y'