APPS.IEX_TRX_GRID_PVT SQL Statements

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

Line: 54

    l_sql_stmt := 'UPDATE iex_delinquencies_all  SET unpaid_reason_code = :b_unpaid_reason ' ||
		  ',last_update_date = SYSDATE ' ||
		  ',last_updated_by = :b_last_updated_by ' ||
		  ',last_update_login = :b_last_update_login ' ||
                  'WHERE delinquency_id IN (' || p_del_ids  || ')';

Line: 65

    DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);

Line: 66

    DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);

Line: 136

    UPDATE iex_delinquencies_all
    SET staged_dunning_level = p_stg_dunn_level
	,last_update_date = SYSDATE
	,last_updated_by = FND_GLOBAL.USER_ID
	,last_update_login = FND_GLOBAL.CONC_LOGIN_ID
        ,dunning_level_override_date = SYSDATE
    WHERE delinquency_id = p_delinquency_id;