DBA Data[Home] [Help]

APPS.HRI_OPL_ORGH_CT dependencies on PER_ORGANIZATION_STRUCTURES

Line 458: ,per_organization_structures ost

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)
462: -- or, Profile

Line 484: ,per_organization_structures ost

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
488: AND NOT EXISTS