APPS.PER_PERCACEI_XMLP_PKG SQL Statements

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

Line: 46

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

Line: 71

      SELECT
        CONSOLIDATION_SET_NAME
      INTO
        CP_CONSOLIDATION
      FROM
        PAY_CONSOLIDATION_SETS
      WHERE CONSOLIDATION_SET_ID = P_CONSOLIDATION_SET_ID;

Line: 80

      SELECT
        PAYROLL_NAME
      INTO
        CP_PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F
      WHERE PAYROLL_ID = P_PAYROLL_ID;

Line: 89

      SELECT
        LTRIM(RTRIM(SUBSTR(NAME
                          ,1
                          ,50)))
      INTO
        CP_GRE
      FROM
        HR_TAX_UNITS_V
      WHERE TAX_UNIT_ID = P_TAX_UNIT_ID;