APPS.BNE_LCT_TOOLS_PKG SQL Statements

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

Line: 13

  SELECT APPLICATION_SHORT_NAME
  INTO   V_ASN
  FROM FND_APPLICATION
  WHERE APPLICATION_ID = X_APP_ID;

Line: 33

  SELECT APPLICATION_ID
  INTO   V_APP_ID
  FROM FND_APPLICATION
  WHERE APPLICATION_SHORT_NAME = X_ASN;

Line: 110

  SELECT ATTRIBUTE9
  FROM   BNE_ATTRIBUTES A, BNE_PARAM_LIST_ITEMS I
  WHERE  A.APPLICATION_ID  = I.ATTRIBUTE_APP_ID
  AND    A.ATTRIBUTE_CODE  = I.ATTRIBUTE_CODE
  AND    I.APPLICATION_ID  = CP_APPLICATION_ID
  AND    I.PARAM_LIST_CODE = CP_PARAM_LIST_CODE
  AND    ATTRIBUTE9 IS NOT NULL
  ORDER BY I.SEQUENCE_NUM;

Line: 153

  SELECT PARAM_NAME,
         STRING_VALUE,
         ATTRIBUTE_APP_ID,
         ATTRIBUTE_CODE
  FROM   BNE_PARAM_LIST_ITEMS
  WHERE  APPLICATION_ID  = CP_APPLICATION_ID
  AND    PARAM_LIST_CODE = CP_PARAM_LIST_CODE;

Line: 343

  SELECT A.*
  FROM   BNE_PARAM_LIST_ITEMS LI, BNE_PARAM_DEFNS_B PD, BNE_ATTRIBUTES A
  WHERE  LI.PARAM_DEFN_APP_ID = PD.APPLICATION_ID
  AND    LI.PARAM_DEFN_CODE = PD.PARAM_DEFN_CODE
  AND    PD.PARAM_SOURCE = 'WEBADI:ViewerExtension'
  AND    A.APPLICATION_ID = PD.ATTRIBUTE_APP_ID
  AND    A.ATTRIBUTE_CODE = PD.ATTRIBUTE_CODE
  AND    LI.APPLICATION_ID  = CP_APPLICATION_ID
  AND    LI.PARAM_LIST_CODE = CP_PARAM_LIST_CODE;