APPS.OE_SYS_PARAMETERS_PVT SQL Statements

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

Line: 62

      SELECT parameter_value
      FROM  oe_sys_parameters_all
      WHERE parameter_code = p_parameter_code
      AND   org_id = p_org_id;

Line: 125

     SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
                NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
     FROM DUAL;

Line: 476

     SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
            NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
     INTO l_org_id FROM DUAL;

Line: 514

     SELECT  *
     INTO
     l_AR_Sys_Param_Rec
     FROM AR_SYSTEM_PARAMETERS_ALL
     WHERE org_id = l_org_id;