APPS.AP_WEB_DB_UI_SETUP_PKG SQL Statements

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

Line: 12

    SELECT displayed_field
    INTO   p_displayed_field
    FROM   ap_lookup_codes
    WHERE  lookup_type = p_lookup_type
    AND    lookup_code = p_lookup_code;

Line: 39

  SELECT  rowidtochar(ROWID)
  INTO    P_ROW_ID
  FROM    AK_FLOW_REGION_RELATIONS
  WHERE   FROM_REGION_CODE = P_FROM_REGION_CODE
  AND     FROM_REGION_APPL_ID = P_APPLICATION_ID
  AND     FROM_PAGE_CODE = P_FROM_PAGE_CODE
  AND     FROM_PAGE_APPL_ID = P_APPLICATION_ID
  AND     TO_PAGE_CODE = P_TO_PAGE_CODE
  AND     TO_PAGE_APPL_ID = P_APPLICATION_ID
  AND     FLOW_CODE = P_FLOW_CODE
  AND     FLOW_APPLICATION_ID = P_APPLICATION_ID;