APPS.PAY_PAYGBP45_XMLP_PKG SQL Statements

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

Line: 10

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

Line: 31

      SELECT
        SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
                                               ,'TAX_REF')
              ,1
              ,3),
        SUBSTR(LTRIM(SUBSTR(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(P.LEGISLATIVE_PARAMETERS
                                                            ,'TAX_REF')
                           ,4
                           ,11)
                    ,'/')
              ,1
              ,10),
        SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID
                                              ,'X_EMPLOYERS_ADDRESS_LINE'
                                              ,'0')
              ,1
              ,60),
        SUBSTR(PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(P.PAYROLL_ACTION_ID
                                              ,'X_EMPLOYERS_NAME'
                                              ,'0')
              ,1
              ,40)
      INTO C_TAX_DIST_NO,C_TAX_DIST_REF,L_ERS_ADDRESS,C_ERS_NAME
      FROM
        PAY_PAYROLL_ACTIONS P
      WHERE P.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID;

Line: 294

      SELECT
        1
      INTO L_3_PART
      FROM
        FF_GLOBALS_F
      WHERE GLOBAL_NAME = 'P45_REPORT_TYPE'
        AND SUBSTR(GLOBAL_VALUE
            ,1
            ,1) = '3'
        AND sysdate between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE;