APPS.PER_PERBGSYN_XMLP_PKG SQL Statements

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

Line: 9

        SELECT
          FULL_NAME,
          PARTY_ID
        INTO
          C_PERSON_NAME
          ,C_PARTY_ID
        FROM
          PER_ALL_PEOPLE_F
        WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
          AND PERSON_ID = P_PERSON_ID
          AND C_EFFECTIVE_DATE between EFFECTIVE_START_DATE
          AND EFFECTIVE_END_DATE;

Line: 27

      SELECT
        NAME
      INTO
        C_BUSINESS_GROUP_NAME
      FROM
        PER_BUSINESS_GROUPS
      WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;