APPS.AHL_DI_PRO_TYPE_ASO_PUB SQL Statements

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

Line: 31

SELECT lookup_code
  FROM FND_LOOKUP_VALUES_VL
 WHERE lookup_type = c_lookup_type
   AND lookup_code = c_lookup_code
   AND sysdate between start_date_active
   AND nvl(end_date_active,sysdate);

Line: 41

 SELECT lookup_code
    FROM FND_LOOKUP_VALUES_VL
  WHERE lookup_type = c_lookup_type
    AND meaning     = c_meaning
    AND sysdate between start_date_active
    AND nvl(end_date_active,sysdate);

Line: 169

        l_doc_type_assoc_tbl(i).delete_flag          := p_x_doc_type_assoc_tbl(i).delete_flag;

Line: 436

/* description :  Updates the existing association   */
/*                record, and removes as well        */
/*                                                   */
/*---------------------------------------------------*/
PROCEDURE MODIFY_DOC_TYPE_ASSOC
(
 p_api_version               IN     NUMBER    :=  1.0              ,
 p_init_msg_list             IN     VARCHAR2  := FND_API.G_TRUE    ,
 p_commit                    IN     VARCHAR2  := FND_API.G_FALSE   ,
 p_validate_only             IN     VARCHAR2  := FND_API.G_TRUE    ,
 p_validation_level          IN     NUMBER    := FND_API.G_VALID_LEVEL_FULL,
 p_x_doc_type_assoc_tbl      IN OUT NOCOPY doc_type_assoc_tbl      ,
 p_module_type               IN     VARCHAR2                       ,
 x_return_status                OUT NOCOPY VARCHAR2                       ,
 x_msg_count                    OUT NOCOPY NUMBER                         ,
 x_msg_data                     OUT NOCOPY VARCHAR2
)
IS
CURSOR lookup_code_info(c_lookup_type VARCHAR2,
                        c_lookup_code VARCHAR2)
 IS
SELECT lookup_code
  FROM FND_LOOKUP_VALUES_VL
 WHERE lookup_type = c_lookup_type
   AND lookup_code = c_lookup_code
   AND sysdate between start_date_active
   AND nvl(end_date_active,sysdate);

Line: 467

 SELECT lookup_code
    FROM FND_LOOKUP_VALUES_VL
  WHERE lookup_type = c_lookup_type
    AND meaning     = c_meaning
    AND sysdate between start_date_active
    AND nvl(end_date_active,sysdate);

Line: 588

        l_doc_type_assoc_tbl(i).delete_flag          := p_x_doc_type_assoc_tbl(i).delete_flag;