APPS.PQH_PSF_BUS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 4215: per_org_structure_versions ver

4211: cursor csr_pc_version (p_effective_date in date,
4212: p_business_group_id in number) is
4213: SELECT org_structure_version_id
4214: FROM per_organization_structures pos,
4215: per_org_structure_versions ver
4216: WHERE pos.organization_structure_id = ver.organization_structure_id
4217: AND p_effective_date BETWEEN ver.date_from AND NVL(ver.date_to, p_effective_date)
4218: AND NVL(pos.position_control_structure_flg,'N') = 'Y'
4219: AND pos.business_group_id = p_business_group_id;