APPS.SSP_SSPRPSPA_XMLP_PKG SQL Statements

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

Line: 13

      INSERT INTO FND_SESSIONS
        (SESSION_ID
        ,EFFECTIVE_DATE)
        SELECT
          USERENV('sessionid'),
          TRUNC(SYSDATE)
        FROM
          SYS.DUAL
        WHERE not exists (
          SELECT
            1
          FROM
            FND_SESSIONS FS
          WHERE FS.SESSION_ID = USERENV('sessionid') );

Line: 29

        SELECT
          DISTINCT
          PAYROLL_NAME
        INTO C_PAYROLL_NAME
        FROM
          PAY_PAYROLLS
        WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
          AND PAYROLL_ID = P_PAYROLL_ID;

Line: 39

        SELECT
          DISTINCT
          SUBSTR(FULL_NAME
                ,1
                ,80)
        INTO C_PERSON_NAME
        FROM
          PER_PEOPLE_F PPF
        WHERE PERSON_ID = P_PERSON_ID
          AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
          AND ( ( P_SESSION_DATE between PPF.EFFECTIVE_START_DATE
          AND PPF.EFFECTIVE_END_DATE )
        OR ( P_SESSION_DATE > PPF.EFFECTIVE_END_DATE
          AND PPF.EFFECTIVE_END_DATE = (
          SELECT
            MAX(P1.EFFECTIVE_END_DATE)
          FROM
            PER_ALL_PEOPLE_F P1
          WHERE P1.PERSON_ID = PPF.PERSON_ID ) )
        OR ( P_SESSION_DATE < PPF.EFFECTIVE_START_DATE
          AND PPF.EFFECTIVE_START_DATE = PPF.START_DATE ) );

Line: 98

      SELECT
        AVERAGE_EARNINGS_AMOUNT
      INTO AVG_EARNINGS
      FROM
        SSP_EARNINGS_CALCULATIONS
      WHERE EFFECTIVE_DATE = QW
        AND PERSON_ID = M_PERSON_ID;