APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 552: per_org_structure_versions posv

548: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG
549: cursor csr_org_struct_version is
550: select posv.org_structure_version_id
551: from per_organization_structures pos,
552: per_org_structure_versions posv
553: where pos.primary_structure_flag = 'Y'
554: and pos.business_group_id = p_business_group_id
555: and pos.organization_structure_id = posv.organization_structure_id
556: and p_effective_date between posv.date_from and nvl(posv.date_to,p_effective_date);