DBA Data[Home] [Help]

APPS.PER_VIEWS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 461: from per_org_structure_elements str

457: -- from the child organization and return the parent org name
458: --------------------------------------------------------------
459: select str.organization_id_parent
460: into org_id_parent
461: from per_org_structure_elements str
462: where level = p_level
463: connect by str.organization_id_child = prior str.organization_id_parent
464: and str.org_structure_version_id = p_org_structure_version_id
465: and str.business_group_id = p_business_group_id