The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT average_balances_flag
INTO ADB_USED
FROM GL_SYSTEM_USAGES;
OUTPUT=":SELECT_FROM_FLEX" TABLEALIAS="CFM"');*/null;
Select name,from_coa_id, to_coa_id,
description,start_date_active,end_date_active
from gl_coa_mappings
where coa_mapping_id = map_id;
SELECT ID_FLEX_STRUCTURE_NAME
FROM FND_ID_FLEX_STRUCTURES_V
WHERE APPLICATION_ID = 101
AND ID_FLEX_CODE = 'GL#'
AND ID_FLEX_NUM = x_segment;
Function SELECT_FROM_FLEX_LOW_p return varchar2 is
Begin
return SELECT_FROM_FLEX_LOW;
Function SELECT_TO_FLEX_p return varchar2 is
Begin
return SELECT_TO_FLEX;
Function SELECT_FROM_FLEX_HIGH_p return varchar2 is
Begin
return SELECT_FROM_FLEX_HIGH;