APPS.PAY_PAYIECHL_XMLP_PKG SQL Statements

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

Line: 50

      SELECT
        PAYEE_ID,
        PAYEE_TYPE
      FROM
        PAY_PERSONAL_PAYMENT_METHODS_F
      WHERE PERSONAL_PAYMENT_METHOD_ID = PERSONAL_PAYMENT_METHOD_ID
        AND DATE_EARNED between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE;

Line: 59

      SELECT
        FIRST_NAME,
        MIDDLE_NAMES,
        LAST_NAME
      FROM
        PER_ALL_PEOPLE_F
      WHERE PERSON_ID = P_PERSON_ID
        AND DATE_EARNED between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE;

Line: 69

      SELECT
        NAME
      FROM
        HR_ALL_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;