APPS.PAY_PAYGBP35_XMLP_PKG SQL Statements

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

Line: 305

      SELECT
        A.BUSINESS_GROUP_ID,
        A.REQUEST_ID,
        A.LEGISLATIVE_PARAMETERS,
        A.START_DATE,
        A.EFFECTIVE_DATE,
        TO_NUMBER(SUBSTR(TO_CHAR(A.START_DATE
                                ,'DD-MM-YYYY')
                        ,7
                        ,4))
      INTO L_BUSINESS_GROUP_ID,C_REQUEST_ID,L_LEGISLATIVE_PARAMETERS,C_START_DATE,C_END_DATE,C_DATE_FROM
      FROM
        PAY_PAYROLL_ACTIONS A
      WHERE A.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID;