APPS.FFDBITEM SQL Statements

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

Line: 62

  SELECT RP.SEQUENCE_NO,
         RP.PARAMETER_NAME,
         UPPER(RP.DATA_TYPE),
         RPV.VALUE
  FROM   FF_ROUTE_PARAMETERS RP,
         FF_ROUTE_PARAMETER_VALUES RPV
  WHERE  RP.ROUTE_ID = p_route_id
  AND    RP.ROUTE_PARAMETER_ID = RPV.ROUTE_PARAMETER_ID
  AND    RPV.USER_ENTITY_ID = p_user_entity_id
  ORDER  BY RP.SEQUENCE_NO;

Line: 136

  SELECT RCU.SEQUENCE_NO,
         FC.CONTEXT_NAME,
         UPPER(FC.DATA_TYPE)
  FROM   FF_CONTEXTS FC,
         FF_ROUTE_CONTEXT_USAGES RCU
  WHERE  FC.CONTEXT_ID = RCU.CONTEXT_ID
  AND    RCU.ROUTE_ID = p_route_id
  ORDER BY RCU.SEQUENCE_NO;

Line: 220

SELECT DI.DATA_TYPE,
       UE.USER_ENTITY_ID,
       UPPER(DI.NULL_ALLOWED_FLAG),
       UPPER(UE.NOTFOUND_ALLOWED_FLAG),
       FR.ROUTE_ID,
       DI.DEFINITION_TEXT,
       FR.TEXT
FROM   FF_DATABASE_ITEMS DI,
       FF_USER_ENTITIES UE,
       FF_ROUTES FR
WHERE  DI.USER_ENTITY_ID = UE.USER_ENTITY_ID
AND    UE.ROUTE_ID = FR.ROUTE_ID
AND    DI.USER_NAME = p_item_name
AND (   (UE.LEGISLATION_CODE IS NULL AND UE.BUSINESS_GROUP_ID IS NULL)
     OR (UE.BUSINESS_GROUP_ID IS NULL AND p_leg_code = UE.LEGISLATION_CODE )
     OR (p_bg_id = UE.BUSINESS_GROUP_ID)
    )
AND NOT EXISTS (
               SELECT CONTEXT_ID FROM FF_ROUTE_CONTEXT_USAGES IFRCU
               WHERE IFRCU.ROUTE_ID = FR.ROUTE_ID
               MINUS
               SELECT CONTEXT_ID FROM FF_FTYPE_CONTEXT_USAGES
               WHERE FORMULA_TYPE_ID = p_formula_type_id
               );

Line: 276

  l_route_text := 'select '||l_definition_text||' from '||l_route_text;