APPS.HR_BIS_ALERTS dependencies on PER_ORG_STRUCTURE_ELEMENTS
Line 883: FROM per_org_structure_elements ose
879: --
880: CURSOR oh_cur(p_org_structure_version_id IN NUMBER
881: ,p_organization_id IN NUMBER) IS
882: SELECT 1 883: FROM per_org_structure_elements ose 884: WHERE ose.org_structure_version_id = p_org_structure_version_id
885: AND (ose.organization_id_child = p_organization_id
886: or ose.organization_id_parent = p_organization_id
887: ) ;