DBA Data[Home] [Help]

APPS.HRI_OPL_ORGH_CT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 457: per_org_structure_versions osv

453: CURSOR hrchy_csr(v_structure_id NUMBER) IS
454: SELECT
455: osv.org_structure_version_id
456: FROM
457: per_org_structure_versions osv
458: ,per_organization_structures ost
459: WHERE ost.organization_structure_id = osv.organization_structure_id
460: -- Primary Global
461: AND ((ost.primary_structure_flag = 'Y' AND osv.business_group_id IS NULL)

Line 483: ,per_org_structure_versions osv

479: ,NVL(osv.date_to,g_end_of_time) end_date
480: ,osv.business_group_id bgr_id
481: FROM
482: per_org_structure_elements ose
483: ,per_org_structure_versions osv
484: ,per_organization_structures ost
485: WHERE osv.org_structure_version_id = ose.org_structure_version_id
486: AND ost.organization_structure_id = osv.organization_structure_id
487: AND osv.org_structure_version_id = v_version_id