APPS.HRI_BPL_CCMGR SQL Statements

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

Line: 8

  SELECT
   o_mgr.org_information2
  FROM
   hri_cl_org_cc_v cl_cc
  ,hr_organization_information o_mgr
  WHERE o_mgr.org_information_context = 'Organization Name Alias'
  AND cl_cc.ID = o_mgr.organization_id
  AND cl_cc.ID = p_organization_id;