DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 1214: per_org_structure_versions posv

1210: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG
1211: cursor csr_org_struct_version is
1212: select posv.org_structure_version_id
1213: from per_organization_structures pos,
1214: per_org_structure_versions posv
1215: where pos.primary_structure_flag = 'Y'
1216: and pos.business_group_id = p_business_group_id
1217: and pos.organization_structure_id = posv.organization_structure_id
1218: and p_effective_date between posv.date_from and nvl(posv.date_to,p_effective_date);