APPS.PER_ORG_BGT_PKG SQL Statements

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

Line: 34

  SELECT  COUNT(E.PERSON_ID),
	  '** ' || COUNT(E.PERSON_ID) ||' '|| X_MANAGER_NAME,
	  MAX(E.FULL_NAME),
          MAX(E.EMPLOYEE_NUMBER)
  INTO	  X_NO_OF_MANAGERS,
	  X_MANAGER_NAME,
	  l_real_manager_name,
	  X_MANAGER_EMP_NO
  FROM    PER_ALL_PEOPLE E
  ,       PER_ALL_ASSIGNMENTS A
  WHERE   E.CURRENT_EMPLOYEE_FLAG = 'Y'
  AND     A.PERSON_ID             = E.PERSON_ID
  AND     A.ORGANIZATION_ID       = X_ORGANIZATION_ID
  AND     A.BUSINESS_GROUP_ID     = X_BUSINESS_GROUP_ID
  AND     A.ASSIGNMENT_TYPE       = 'E'
  AND     A.MANAGER_FLAG          = 'Y';