APPS.PQH_PSF_BUS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 4603: per_org_structure_versions ver

4599: cursor csr_pc_version (p_effective_date in date,
4600: p_business_group_id in number) is
4601: SELECT org_structure_version_id
4602: FROM per_organization_structures pos,
4603: per_org_structure_versions ver
4604: WHERE pos.organization_structure_id = ver.organization_structure_id
4605: AND p_effective_date BETWEEN ver.date_from AND NVL(ver.date_to, p_effective_date)
4606: AND NVL(pos.position_control_structure_flg,'N') = 'Y'
4607: AND pos.business_group_id = p_business_group_id;