APPS.IEC_RLC_CTRL_PVT SQL Statements

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

Line: 38

          l_rlse_stmt := 'select list_entry_id from '|| P_VIEW_NAME
		|| ' where list_entry_id in '|| l_list_entry_id_list
		|| ' and list_header_id = '|| P_LIST_HEADER_ID || ' and ('||
		l_where_clause || ' )';

Line: 85

	UPDATE AMS_LIST_ENTRIES
	set DO_NOT_USE_FLAG='N',DO_NOT_USE_REASON=null where LIST_HEADER_ID= P_LIST_HEADER_ID and DO_NOT_USE_FLAG='Y' and DO_NOT_USE_REASON=P_DO_NOT_USE_REASON;

Line: 104

	select list_header_id from ams_list_headers_all where release_control_alg_id = P_RLSE_CTRL_ID;