APPS.HRI_BPL_ORG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

  SELECT sub_organization_id
  FROM hri_cs_orgh_v orh
  WHERE orh.org_hierarchy_version_id = cp_org_hierarchy_version_id
  AND orh.sup_organization_id = cp_sup_organization_id;

Line: 113

  SELECT organization_structure_id
  FROM per_security_profiles
  WHERE security_profile_id = p_security_profile_id;

Line: 145

  SELECT 1
  FROM per_org_structure_versions
  WHERE organization_structure_id = p_organization_structure_id
  AND org_structure_version_id = p_org_structure_version_id;